﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CoreBizDBDataSet" targetNamespace="http://tempuri.org/CoreBizDBDataSet.xsd" xmlns:mstns="http://tempuri.org/CoreBizDBDataSet.xsd" xmlns="http://tempuri.org/CoreBizDBDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="CoreBizDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CoreBizDBConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.CoreBizDBConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DriversTableAdapter" GeneratorDataComponentClassName="DriversTableAdapter" Name="Drivers" UserDataComponentName="DriversTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoreBizDBConnectionString (Web.config)" DbObjectName="CoreBizDB.HeavyLift.Drivers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [HeavyLift].[Drivers] WHERE (([CivilID] = @Original_CivilID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CivilID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CivilID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [HeavyLift].[Drivers] ([CivilID], [FirstName], [MiddleName], [LastName], [ArabicFirstName], [ArabicMiddleName], [ArabicLastName], [CountryCode], [DateOfBirth], [SpouseName], [FathersName], [GrandFathersName], [GrandMothersName], [MothersName], [MothersFatherName], [MartialStatus], [CityOfBirth], [PlaceOfBirth], [EyeColor], [HairColor], [HeightInCM], [HeightInFeet], [WeightInKG], [WeightInLbs], [Race], [Religion], [BloodGroup], [PermanentAddess], [LocalAddress], [Education], [Specialization], [Photo], [SocialSecurityNo], [PassportNo], [PassportDateOfIssue], [PassportDateOfExpiry], [PassportPlaceOfIssue], [MasterListNo], [EmployeeNo], [ExternalEmployeeNo], [ContactNo], [ExtensionNo], [FaxNo], [NextOfKin], [KinRelationship], [KinContactNo], [KinNativelLanguage], [DepartmentCode], [DesignationCode], [CompanyCode], [DesignationArabic], [LeaveEntitled], [LeaveAccrued], [AccomodationCode], [PayByCash], [BankName], [BankAccountNo], [ExpectedDateOfJoining], [DateOfJoining], [ResidencyNo], [ResidencyExpairyDate], [CivilIDExpairyDate], [DrivingLicenceNo], [DrivingLicenceExpiryDate], [ShuaibaPassNo], [ShuaibaPassExpiryDate], [ShuaibaPassRemarks], [J2SouthPassNo], [J2SouthPassExpiry], [J2SouthPassRemark], [J2NorthPassNo], [J2NorthPassExpiry], [J2NorthPassRemarks], [USFVirginiaBadgeNo], [USFVirginiaBadgeExpiry], [USFVirginiaBadgeRemarks], [ASGKUBadgeNo], [ASGKUBadgeExpiry], [ASGKUBadgeRemarks], [TrainingRemark], [ViolationRemark], [AccidentRemark], [Remark1], [Remark2], [Remark3], [Remark4], [Remark5], [Remark6], [DriverMissionStatus], [DriverHRStatus], [InsertedUser], [InsertedDate], [UpdatedUser], [UpdatedDate], [DataVersion]) VALUES (@CivilID, @FirstName, @MiddleName, @LastName, @ArabicFirstName, @ArabicMiddleName, @ArabicLastName, @CountryCode, @DateOfBirth, @SpouseName, @FathersName, @GrandFathersName, @GrandMothersName, @MothersName, @MothersFatherName, @MartialStatus, @CityOfBirth, @PlaceOfBirth, @EyeColor, @HairColor, @HeightInCM, @HeightInFeet, @WeightInKG, @WeightInLbs, @Race, @Religion, @BloodGroup, @PermanentAddess, @LocalAddress, @Education, @Specialization, @Photo, @SocialSecurityNo, @PassportNo, @PassportDateOfIssue, @PassportDateOfExpiry, @PassportPlaceOfIssue, @MasterListNo, @EmployeeNo, @ExternalEmployeeNo, @ContactNo, @ExtensionNo, @FaxNo, @NextOfKin, @KinRelationship, @KinContactNo, @KinNativelLanguage, @DepartmentCode, @DesignationCode, @CompanyCode, @DesignationArabic, @LeaveEntitled, @LeaveAccrued, @AccomodationCode, @PayByCash, @BankName, @BankAccountNo, @ExpectedDateOfJoining, @DateOfJoining, @ResidencyNo, @ResidencyExpairyDate, @CivilIDExpairyDate, @DrivingLicenceNo, @DrivingLicenceExpiryDate, @ShuaibaPassNo, @ShuaibaPassExpiryDate, @ShuaibaPassRemarks, @J2SouthPassNo, @J2SouthPassExpiry, @J2SouthPassRemark, @J2NorthPassNo, @J2NorthPassExpiry, @J2NorthPassRemarks, @USFVirginiaBadgeNo, @USFVirginiaBadgeExpiry, @USFVirginiaBadgeRemarks, @ASGKUBadgeNo, @ASGKUBadgeExpiry, @ASGKUBadgeRemarks, @TrainingRemark, @ViolationRemark, @AccidentRemark, @Remark1, @Remark2, @Remark3, @Remark4, @Remark5, @Remark6, @DriverMissionStatus, @DriverHRStatus, @InsertedUser, @InsertedDate, @UpdatedUser, @UpdatedDate, @DataVersion)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CivilID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CivilID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ArabicFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArabicFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ArabicMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArabicMiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ArabicLastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArabicLastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateOfBirth" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SpouseName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpouseName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FathersName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FathersName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GrandFathersName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GrandFathersName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GrandMothersName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GrandMothersName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MothersName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MothersName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MothersFatherName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MothersFatherName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MartialStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MartialStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CityOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EyeColor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EyeColor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HairColor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HairColor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@HeightInCM" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="HeightInCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@HeightInFeet" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="HeightInFeet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@WeightInKG" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="WeightInKG" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@WeightInLbs" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="WeightInLbs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Race" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Race" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Religion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Religion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BloodGroup" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BloodGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PermanentAddess" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PermanentAddess" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LocalAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LocalAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Education" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Education" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Specialization" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Specialization" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SocialSecurityNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SocialSecurityNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PassportNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PassportNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@PassportDateOfIssue" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="PassportDateOfIssue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@PassportDateOfExpiry" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="PassportDateOfExpiry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PassportPlaceOfIssue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PassportPlaceOfIssue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MasterListNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterListNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EmployeeNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EmployeeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ExternalEmployeeNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ExternalEmployeeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ExtensionNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ExtensionNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FaxNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FaxNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NextOfKin" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NextOfKin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KinRelationship" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KinRelationship" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KinContactNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KinContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KinNativelLanguage" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KinNativelLanguage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DepartmentCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DesignationCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DesignationCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CompanyCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CompanyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DesignationArabic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DesignationArabic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LeaveEntitled" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LeaveEntitled" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LeaveAccrued" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LeaveAccrued" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccomodationCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccomodationCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PayByCash" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PayByCash" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BankAccountNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankAccountNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ExpectedDateOfJoining" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ExpectedDateOfJoining" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateOfJoining" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateOfJoining" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ResidencyNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ResidencyNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ResidencyExpairyDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ResidencyExpairyDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@CivilIDExpairyDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CivilIDExpairyDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DrivingLicenceNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DrivingLicenceNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DrivingLicenceExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DrivingLicenceExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShuaibaPassNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShuaibaPassNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ShuaibaPassExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ShuaibaPassExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShuaibaPassRemarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShuaibaPassRemarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@J2SouthPassNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="J2SouthPassNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@J2SouthPassExpiry" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="J2SouthPassExpiry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@J2SouthPassRemark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="J2SouthPassRemark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@J2NorthPassNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="J2NorthPassNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@J2NorthPassExpiry" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="J2NorthPassExpiry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@J2NorthPassRemarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="J2NorthPassRemarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USFVirginiaBadgeNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USFVirginiaBadgeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@USFVirginiaBadgeExpiry" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="USFVirginiaBadgeExpiry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USFVirginiaBadgeRemarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USFVirginiaBadgeRemarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ASGKUBadgeNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ASGKUBadgeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ASGKUBadgeExpiry" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ASGKUBadgeExpiry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ASGKUBadgeRemarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ASGKUBadgeRemarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TrainingRemark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TrainingRemark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ViolationRemark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ViolationRemark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccidentRemark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccidentRemark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark6" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark6" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DriverMissionStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DriverMissionStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DriverHRStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DriverHRStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InsertedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InsertedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@InsertedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="InsertedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UpdatedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UpdatedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@DataVersion" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="DataVersion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CivilID, FirstName, MiddleName, LastName, ArabicFirstName, ArabicMiddleName, ArabicLastName, CountryCode, DateOfBirth, Age, SpouseName, FathersName, GrandFathersName, GrandMothersName, MothersName, MothersFatherName, MartialStatus, CityOfBirth, PlaceOfBirth, EyeColor, HairColor, HeightInCM, HeightInFeet, WeightInKG, WeightInLbs, Race, Religion, BloodGroup, PermanentAddess, LocalAddress, Education, Specialization, Photo, SocialSecurityNo, PassportNo, PassportDateOfIssue, PassportDateOfExpiry, PassportPlaceOfIssue, MasterListNo, EmployeeNo, ExternalEmployeeNo, ContactNo, ExtensionNo, FaxNo, NextOfKin, KinRelationship, KinContactNo, KinNativelLanguage, DepartmentCode, DesignationCode, CompanyCode, DesignationArabic, LeaveEntitled, LeaveAccrued, AccomodationCode, PayByCash, BankName, BankAccountNo, ExpectedDateOfJoining, DateOfJoining, ResidencyNo, ResidencyExpairyDate, CivilIDExpairyDate, DrivingLicenceNo, DrivingLicenceExpiryDate, ShuaibaPassNo, ShuaibaPassExpiryDate, ShuaibaPassRemarks, J2SouthPassNo, J2SouthPassExpiry, J2SouthPassRemark, J2NorthPassNo, J2NorthPassExpiry, J2NorthPassRemarks, USFVirginiaBadgeNo, USFVirginiaBadgeExpiry, USFVirginiaBadgeRemarks, ASGKUBadgeNo, ASGKUBadgeExpiry, ASGKUBadgeRemarks, TrainingRemark, ViolationRemark, AccidentRemark, Remark1, Remark2, Remark3, Remark4, Remark5, Remark6, DriverMissionStatus, DriverHRStatus, InsertedUser, InsertedDate, UpdatedUser, UpdatedDate, DataVersion FROM HeavyLift.Drivers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [HeavyLift].[Drivers] SET [CivilID] = @CivilID, [FirstName] = @FirstName, [MiddleName] = @MiddleName, [LastName] = @LastName, [ArabicFirstName] = @ArabicFirstName, [ArabicMiddleName] = @ArabicMiddleName, [ArabicLastName] = @ArabicLastName, [CountryCode] = @CountryCode, [DateOfBirth] = @DateOfBirth, [SpouseName] = @SpouseName, [FathersName] = @FathersName, [GrandFathersName] = @GrandFathersName, [GrandMothersName] = @GrandMothersName, [MothersName] = @MothersName, [MothersFatherName] = @MothersFatherName, [MartialStatus] = @MartialStatus, [CityOfBirth] = @CityOfBirth, [PlaceOfBirth] = @PlaceOfBirth, [EyeColor] = @EyeColor, [HairColor] = @HairColor, [HeightInCM] = @HeightInCM, [HeightInFeet] = @HeightInFeet, [WeightInKG] = @WeightInKG, [WeightInLbs] = @WeightInLbs, [Race] = @Race, [Religion] = @Religion, [BloodGroup] = @BloodGroup, [PermanentAddess] = @PermanentAddess, [LocalAddress] = @LocalAddress, [Education] = @Education, [Specialization] = @Specialization, [Photo] = @Photo, [SocialSecurityNo] = @SocialSecurityNo, [PassportNo] = @PassportNo, [PassportDateOfIssue] = @PassportDateOfIssue, [PassportDateOfExpiry] = @PassportDateOfExpiry, [PassportPlaceOfIssue] = @PassportPlaceOfIssue, [MasterListNo] = @MasterListNo, [EmployeeNo] = @EmployeeNo, [ExternalEmployeeNo] = @ExternalEmployeeNo, [ContactNo] = @ContactNo, [ExtensionNo] = @ExtensionNo, [FaxNo] = @FaxNo, [NextOfKin] = @NextOfKin, [KinRelationship] = @KinRelationship, [KinContactNo] = @KinContactNo, [KinNativelLanguage] = @KinNativelLanguage, [DepartmentCode] = @DepartmentCode, [DesignationCode] = @DesignationCode, [CompanyCode] = @CompanyCode, [DesignationArabic] = @DesignationArabic, [LeaveEntitled] = @LeaveEntitled, [LeaveAccrued] = @LeaveAccrued, [AccomodationCode] = @AccomodationCode, [PayByCash] = @PayByCash, [BankName] = @BankName, [BankAccountNo] = @BankAccountNo, [ExpectedDateOfJoining] = @ExpectedDateOfJoining, [DateOfJoining] = @DateOfJoining, [ResidencyNo] = @ResidencyNo, [ResidencyExpairyDate] = @ResidencyExpairyDate, [CivilIDExpairyDate] = @CivilIDExpairyDate, [DrivingLicenceNo] = @DrivingLicenceNo, [DrivingLicenceExpiryDate] = @DrivingLicenceExpiryDate, [ShuaibaPassNo] = @ShuaibaPassNo, [ShuaibaPassExpiryDate] = @ShuaibaPassExpiryDate, [ShuaibaPassRemarks] = @ShuaibaPassRemarks, [J2SouthPassNo] = @J2SouthPassNo, [J2SouthPassExpiry] = @J2SouthPassExpiry, [J2SouthPassRemark] = @J2SouthPassRemark, [J2NorthPassNo] = @J2NorthPassNo, [J2NorthPassExpiry] = @J2NorthPassExpiry, [J2NorthPassRemarks] = @J2NorthPassRemarks, [USFVirginiaBadgeNo] = @USFVirginiaBadgeNo, [USFVirginiaBadgeExpiry] = @USFVirginiaBadgeExpiry, [USFVirginiaBadgeRemarks] = @USFVirginiaBadgeRemarks, [ASGKUBadgeNo] = @ASGKUBadgeNo, [ASGKUBadgeExpiry] = @ASGKUBadgeExpiry, [ASGKUBadgeRemarks] = @ASGKUBadgeRemarks, [TrainingRemark] = @TrainingRemark, [ViolationRemark] = @ViolationRemark, [AccidentRemark] = @AccidentRemark, [Remark1] = @Remark1, [Remark2] = @Remark2, [Remark3] = @Remark3, [Remark4] = @Remark4, [Remark5] = @Remark5, [Remark6] = @Remark6, [DriverMissionStatus] = @DriverMissionStatus, [DriverHRStatus] = @DriverHRStatus, [InsertedUser] = @InsertedUser, [InsertedDate] = @InsertedDate, [UpdatedUser] = @UpdatedUser, [UpdatedDate] = @UpdatedDate, [DataVersion] = @DataVersion WHERE (([CivilID] = @Original_CivilID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CivilID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CivilID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ArabicFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArabicFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ArabicMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArabicMiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ArabicLastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArabicLastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateOfBirth" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SpouseName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpouseName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FathersName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FathersName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GrandFathersName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GrandFathersName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GrandMothersName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GrandMothersName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MothersName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MothersName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MothersFatherName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MothersFatherName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MartialStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MartialStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CityOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EyeColor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EyeColor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HairColor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HairColor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@HeightInCM" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="HeightInCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@HeightInFeet" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="HeightInFeet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@WeightInKG" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="WeightInKG" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@WeightInLbs" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="WeightInLbs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Race" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Race" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Religion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Religion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BloodGroup" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BloodGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PermanentAddess" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PermanentAddess" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LocalAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LocalAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Education" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Education" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Specialization" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Specialization" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SocialSecurityNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SocialSecurityNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PassportNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PassportNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@PassportDateOfIssue" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="PassportDateOfIssue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@PassportDateOfExpiry" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="PassportDateOfExpiry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PassportPlaceOfIssue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PassportPlaceOfIssue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MasterListNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterListNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EmployeeNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EmployeeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ExternalEmployeeNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ExternalEmployeeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ExtensionNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ExtensionNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FaxNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FaxNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NextOfKin" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NextOfKin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KinRelationship" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KinRelationship" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KinContactNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KinContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KinNativelLanguage" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KinNativelLanguage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DepartmentCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DesignationCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DesignationCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CompanyCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CompanyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DesignationArabic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DesignationArabic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LeaveEntitled" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LeaveEntitled" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LeaveAccrued" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LeaveAccrued" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccomodationCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccomodationCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PayByCash" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PayByCash" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BankAccountNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankAccountNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ExpectedDateOfJoining" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ExpectedDateOfJoining" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateOfJoining" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateOfJoining" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ResidencyNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ResidencyNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ResidencyExpairyDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ResidencyExpairyDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@CivilIDExpairyDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CivilIDExpairyDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DrivingLicenceNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DrivingLicenceNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DrivingLicenceExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DrivingLicenceExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShuaibaPassNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShuaibaPassNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ShuaibaPassExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ShuaibaPassExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShuaibaPassRemarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShuaibaPassRemarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@J2SouthPassNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="J2SouthPassNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@J2SouthPassExpiry" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="J2SouthPassExpiry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@J2SouthPassRemark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="J2SouthPassRemark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@J2NorthPassNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="J2NorthPassNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@J2NorthPassExpiry" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="J2NorthPassExpiry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@J2NorthPassRemarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="J2NorthPassRemarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USFVirginiaBadgeNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USFVirginiaBadgeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@USFVirginiaBadgeExpiry" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="USFVirginiaBadgeExpiry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@USFVirginiaBadgeRemarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="USFVirginiaBadgeRemarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ASGKUBadgeNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ASGKUBadgeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ASGKUBadgeExpiry" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ASGKUBadgeExpiry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ASGKUBadgeRemarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ASGKUBadgeRemarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TrainingRemark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TrainingRemark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ViolationRemark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ViolationRemark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccidentRemark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccidentRemark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark6" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark6" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DriverMissionStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DriverMissionStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DriverHRStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DriverHRStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InsertedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InsertedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@InsertedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="InsertedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UpdatedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UpdatedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@DataVersion" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="DataVersion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CivilID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CivilID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CivilID" DataSetColumn="CivilID" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="MiddleName" DataSetColumn="MiddleName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="ArabicFirstName" DataSetColumn="ArabicFirstName" />
              <Mapping SourceColumn="ArabicMiddleName" DataSetColumn="ArabicMiddleName" />
              <Mapping SourceColumn="ArabicLastName" DataSetColumn="ArabicLastName" />
              <Mapping SourceColumn="CountryCode" DataSetColumn="CountryCode" />
              <Mapping SourceColumn="DateOfBirth" DataSetColumn="DateOfBirth" />
              <Mapping SourceColumn="Age" DataSetColumn="Age" />
              <Mapping SourceColumn="SpouseName" DataSetColumn="SpouseName" />
              <Mapping SourceColumn="FathersName" DataSetColumn="FathersName" />
              <Mapping SourceColumn="GrandFathersName" DataSetColumn="GrandFathersName" />
              <Mapping SourceColumn="GrandMothersName" DataSetColumn="GrandMothersName" />
              <Mapping SourceColumn="MothersName" DataSetColumn="MothersName" />
              <Mapping SourceColumn="MothersFatherName" DataSetColumn="MothersFatherName" />
              <Mapping SourceColumn="MartialStatus" DataSetColumn="MartialStatus" />
              <Mapping SourceColumn="CityOfBirth" DataSetColumn="CityOfBirth" />
              <Mapping SourceColumn="PlaceOfBirth" DataSetColumn="PlaceOfBirth" />
              <Mapping SourceColumn="EyeColor" DataSetColumn="EyeColor" />
              <Mapping SourceColumn="HairColor" DataSetColumn="HairColor" />
              <Mapping SourceColumn="HeightInCM" DataSetColumn="HeightInCM" />
              <Mapping SourceColumn="HeightInFeet" DataSetColumn="HeightInFeet" />
              <Mapping SourceColumn="WeightInKG" DataSetColumn="WeightInKG" />
              <Mapping SourceColumn="WeightInLbs" DataSetColumn="WeightInLbs" />
              <Mapping SourceColumn="Race" DataSetColumn="Race" />
              <Mapping SourceColumn="Religion" DataSetColumn="Religion" />
              <Mapping SourceColumn="BloodGroup" DataSetColumn="BloodGroup" />
              <Mapping SourceColumn="PermanentAddess" DataSetColumn="PermanentAddess" />
              <Mapping SourceColumn="LocalAddress" DataSetColumn="LocalAddress" />
              <Mapping SourceColumn="Education" DataSetColumn="Education" />
              <Mapping SourceColumn="Specialization" DataSetColumn="Specialization" />
              <Mapping SourceColumn="Photo" DataSetColumn="Photo" />
              <Mapping SourceColumn="SocialSecurityNo" DataSetColumn="SocialSecurityNo" />
              <Mapping SourceColumn="PassportNo" DataSetColumn="PassportNo" />
              <Mapping SourceColumn="PassportDateOfIssue" DataSetColumn="PassportDateOfIssue" />
              <Mapping SourceColumn="PassportDateOfExpiry" DataSetColumn="PassportDateOfExpiry" />
              <Mapping SourceColumn="PassportPlaceOfIssue" DataSetColumn="PassportPlaceOfIssue" />
              <Mapping SourceColumn="MasterListNo" DataSetColumn="MasterListNo" />
              <Mapping SourceColumn="EmployeeNo" DataSetColumn="EmployeeNo" />
              <Mapping SourceColumn="ExternalEmployeeNo" DataSetColumn="ExternalEmployeeNo" />
              <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
              <Mapping SourceColumn="ExtensionNo" DataSetColumn="ExtensionNo" />
              <Mapping SourceColumn="FaxNo" DataSetColumn="FaxNo" />
              <Mapping SourceColumn="NextOfKin" DataSetColumn="NextOfKin" />
              <Mapping SourceColumn="KinRelationship" DataSetColumn="KinRelationship" />
              <Mapping SourceColumn="KinContactNo" DataSetColumn="KinContactNo" />
              <Mapping SourceColumn="KinNativelLanguage" DataSetColumn="KinNativelLanguage" />
              <Mapping SourceColumn="DepartmentCode" DataSetColumn="DepartmentCode" />
              <Mapping SourceColumn="DesignationCode" DataSetColumn="DesignationCode" />
              <Mapping SourceColumn="CompanyCode" DataSetColumn="CompanyCode" />
              <Mapping SourceColumn="DesignationArabic" DataSetColumn="DesignationArabic" />
              <Mapping SourceColumn="LeaveEntitled" DataSetColumn="LeaveEntitled" />
              <Mapping SourceColumn="LeaveAccrued" DataSetColumn="LeaveAccrued" />
              <Mapping SourceColumn="AccomodationCode" DataSetColumn="AccomodationCode" />
              <Mapping SourceColumn="PayByCash" DataSetColumn="PayByCash" />
              <Mapping SourceColumn="BankName" DataSetColumn="BankName" />
              <Mapping SourceColumn="BankAccountNo" DataSetColumn="BankAccountNo" />
              <Mapping SourceColumn="ExpectedDateOfJoining" DataSetColumn="ExpectedDateOfJoining" />
              <Mapping SourceColumn="DateOfJoining" DataSetColumn="DateOfJoining" />
              <Mapping SourceColumn="ResidencyNo" DataSetColumn="ResidencyNo" />
              <Mapping SourceColumn="ResidencyExpairyDate" DataSetColumn="ResidencyExpairyDate" />
              <Mapping SourceColumn="CivilIDExpairyDate" DataSetColumn="CivilIDExpairyDate" />
              <Mapping SourceColumn="DrivingLicenceNo" DataSetColumn="DrivingLicenceNo" />
              <Mapping SourceColumn="DrivingLicenceExpiryDate" DataSetColumn="DrivingLicenceExpiryDate" />
              <Mapping SourceColumn="ShuaibaPassNo" DataSetColumn="ShuaibaPassNo" />
              <Mapping SourceColumn="ShuaibaPassExpiryDate" DataSetColumn="ShuaibaPassExpiryDate" />
              <Mapping SourceColumn="ShuaibaPassRemarks" DataSetColumn="ShuaibaPassRemarks" />
              <Mapping SourceColumn="J2SouthPassNo" DataSetColumn="J2SouthPassNo" />
              <Mapping SourceColumn="J2SouthPassExpiry" DataSetColumn="J2SouthPassExpiry" />
              <Mapping SourceColumn="J2SouthPassRemark" DataSetColumn="J2SouthPassRemark" />
              <Mapping SourceColumn="J2NorthPassNo" DataSetColumn="J2NorthPassNo" />
              <Mapping SourceColumn="J2NorthPassExpiry" DataSetColumn="J2NorthPassExpiry" />
              <Mapping SourceColumn="J2NorthPassRemarks" DataSetColumn="J2NorthPassRemarks" />
              <Mapping SourceColumn="USFVirginiaBadgeNo" DataSetColumn="USFVirginiaBadgeNo" />
              <Mapping SourceColumn="USFVirginiaBadgeExpiry" DataSetColumn="USFVirginiaBadgeExpiry" />
              <Mapping SourceColumn="USFVirginiaBadgeRemarks" DataSetColumn="USFVirginiaBadgeRemarks" />
              <Mapping SourceColumn="ASGKUBadgeNo" DataSetColumn="ASGKUBadgeNo" />
              <Mapping SourceColumn="ASGKUBadgeExpiry" DataSetColumn="ASGKUBadgeExpiry" />
              <Mapping SourceColumn="ASGKUBadgeRemarks" DataSetColumn="ASGKUBadgeRemarks" />
              <Mapping SourceColumn="TrainingRemark" DataSetColumn="TrainingRemark" />
              <Mapping SourceColumn="ViolationRemark" DataSetColumn="ViolationRemark" />
              <Mapping SourceColumn="AccidentRemark" DataSetColumn="AccidentRemark" />
              <Mapping SourceColumn="Remark1" DataSetColumn="Remark1" />
              <Mapping SourceColumn="Remark2" DataSetColumn="Remark2" />
              <Mapping SourceColumn="Remark3" DataSetColumn="Remark3" />
              <Mapping SourceColumn="Remark4" DataSetColumn="Remark4" />
              <Mapping SourceColumn="Remark5" DataSetColumn="Remark5" />
              <Mapping SourceColumn="Remark6" DataSetColumn="Remark6" />
              <Mapping SourceColumn="DriverMissionStatus" DataSetColumn="DriverMissionStatus" />
              <Mapping SourceColumn="DriverHRStatus" DataSetColumn="DriverHRStatus" />
              <Mapping SourceColumn="InsertedUser" DataSetColumn="InsertedUser" />
              <Mapping SourceColumn="InsertedDate" DataSetColumn="InsertedDate" />
              <Mapping SourceColumn="UpdatedUser" DataSetColumn="UpdatedUser" />
              <Mapping SourceColumn="UpdatedDate" DataSetColumn="UpdatedDate" />
              <Mapping SourceColumn="DataVersion" DataSetColumn="DataVersion" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VehiclesTableAdapter" GeneratorDataComponentClassName="VehiclesTableAdapter" Name="Vehicles" UserDataComponentName="VehiclesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoreBizDBConnectionString (Web.config)" DbObjectName="CoreBizDB.HeavyLift.Vehicles" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [HeavyLift].[Vehicles] WHERE (([VehicleNumber] = @Original_VehicleNumber))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_VehicleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VehicleNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [HeavyLift].[Vehicles] ([VehicleNumber], [DoorNo], [LicensePlateNumber], [VIN], [MasterListNo], [CompanyCode], [BodyType], [Make], [Model], [Year], [Color], [InsuranceCompany], [InsuranceExpiryDate], [RegistrationExpiryDate], [AppsGivenDate], [ASGPassIssueDate], [ASGPassExpiryDate], [TrailorNo], [KmIn], [KmOut], [SpodNumber], [SpodExpiryDate], [J2ExpiryDate], [Remark1], [Remark2], [Remark3], [Remark4], [Remark5], [Remark6], [VehicleMissionStatus], [VehicleQCStatus], [InsertedUser], [InsertedDate], [UpdatedUser], [UpdatedDate], [DataVersion]) VALUES (@VehicleNumber, @DoorNo, @LicensePlateNumber, @VIN, @MasterListNo, @CompanyCode, @BodyType, @Make, @Model, @Year, @Color, @InsuranceCompany, @InsuranceExpiryDate, @RegistrationExpiryDate, @AppsGivenDate, @ASGPassIssueDate, @ASGPassExpiryDate, @TrailorNo, @KmIn, @KmOut, @SpodNumber, @SpodExpiryDate, @J2ExpiryDate, @Remark1, @Remark2, @Remark3, @Remark4, @Remark5, @Remark6, @VehicleMissionStatus, @VehicleQCStatus, @InsertedUser, @InsertedDate, @UpdatedUser, @UpdatedDate, @DataVersion)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VehicleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VehicleNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DoorNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DoorNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LicensePlateNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LicensePlateNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VIN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@MasterListNo" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="MasterListNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CompanyCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CompanyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BodyType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BodyType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Make" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Make" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Model" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Year" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InsuranceCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InsuranceCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@InsuranceExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="InsuranceExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@RegistrationExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="RegistrationExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@AppsGivenDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="AppsGivenDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ASGPassIssueDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ASGPassIssueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ASGPassExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ASGPassExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TrailorNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TrailorNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@KmIn" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="KmIn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@KmOut" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="KmOut" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SpodNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpodNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@SpodExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="SpodExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@J2ExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="J2ExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark6" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark6" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VehicleMissionStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VehicleMissionStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VehicleQCStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VehicleQCStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InsertedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InsertedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@InsertedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="InsertedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UpdatedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UpdatedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@DataVersion" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="DataVersion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT      *
FROM            HeavyLift.Vehicles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [HeavyLift].[Vehicles] SET [VehicleNumber] = @VehicleNumber, [DoorNo] = @DoorNo, [LicensePlateNumber] = @LicensePlateNumber, [VIN] = @VIN, [MasterListNo] = @MasterListNo, [CompanyCode] = @CompanyCode, [BodyType] = @BodyType, [Make] = @Make, [Model] = @Model, [Year] = @Year, [Color] = @Color, [InsuranceCompany] = @InsuranceCompany, [InsuranceExpiryDate] = @InsuranceExpiryDate, [RegistrationExpiryDate] = @RegistrationExpiryDate, [AppsGivenDate] = @AppsGivenDate, [ASGPassIssueDate] = @ASGPassIssueDate, [ASGPassExpiryDate] = @ASGPassExpiryDate, [TrailorNo] = @TrailorNo, [KmIn] = @KmIn, [KmOut] = @KmOut, [SpodNumber] = @SpodNumber, [SpodExpiryDate] = @SpodExpiryDate, [J2ExpiryDate] = @J2ExpiryDate, [Remark1] = @Remark1, [Remark2] = @Remark2, [Remark3] = @Remark3, [Remark4] = @Remark4, [Remark5] = @Remark5, [Remark6] = @Remark6, [VehicleMissionStatus] = @VehicleMissionStatus, [VehicleQCStatus] = @VehicleQCStatus, [InsertedUser] = @InsertedUser, [InsertedDate] = @InsertedDate, [UpdatedUser] = @UpdatedUser, [UpdatedDate] = @UpdatedDate, [DataVersion] = @DataVersion WHERE (([VehicleNumber] = @Original_VehicleNumber))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VehicleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VehicleNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DoorNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DoorNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LicensePlateNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LicensePlateNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VIN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@MasterListNo" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="MasterListNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CompanyCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CompanyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BodyType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BodyType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Make" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Make" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Model" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Year" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InsuranceCompany" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InsuranceCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@InsuranceExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="InsuranceExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@RegistrationExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="RegistrationExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@AppsGivenDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="AppsGivenDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ASGPassIssueDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ASGPassIssueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ASGPassExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ASGPassExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TrailorNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TrailorNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@KmIn" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="KmIn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@KmOut" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="KmOut" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SpodNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SpodNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@SpodExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="SpodExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@J2ExpiryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="J2ExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark6" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark6" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VehicleMissionStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VehicleMissionStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VehicleQCStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VehicleQCStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InsertedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InsertedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@InsertedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="InsertedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UpdatedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UpdatedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UpdatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UpdatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@DataVersion" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="DataVersion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_VehicleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VehicleNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VehicleNumber" DataSetColumn="VehicleNumber" />
              <Mapping SourceColumn="DoorNo" DataSetColumn="DoorNo" />
              <Mapping SourceColumn="LicensePlateNumber" DataSetColumn="LicensePlateNumber" />
              <Mapping SourceColumn="VIN" DataSetColumn="VIN" />
              <Mapping SourceColumn="MasterListNo" DataSetColumn="MasterListNo" />
              <Mapping SourceColumn="CompanyCode" DataSetColumn="CompanyCode" />
              <Mapping SourceColumn="BodyType" DataSetColumn="BodyType" />
              <Mapping SourceColumn="Make" DataSetColumn="Make" />
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="Color" DataSetColumn="Color" />
              <Mapping SourceColumn="InsuranceCompany" DataSetColumn="InsuranceCompany" />
              <Mapping SourceColumn="InsuranceExpiryDate" DataSetColumn="InsuranceExpiryDate" />
              <Mapping SourceColumn="RegistrationExpiryDate" DataSetColumn="RegistrationExpiryDate" />
              <Mapping SourceColumn="AppsGivenDate" DataSetColumn="AppsGivenDate" />
              <Mapping SourceColumn="ASGPassIssueDate" DataSetColumn="ASGPassIssueDate" />
              <Mapping SourceColumn="ASGPassExpiryDate" DataSetColumn="ASGPassExpiryDate" />
              <Mapping SourceColumn="TrailorNo" DataSetColumn="TrailorNo" />
              <Mapping SourceColumn="KmIn" DataSetColumn="KmIn" />
              <Mapping SourceColumn="KmOut" DataSetColumn="KmOut" />
              <Mapping SourceColumn="SpodNumber" DataSetColumn="SpodNumber" />
              <Mapping SourceColumn="SpodExpiryDate" DataSetColumn="SpodExpiryDate" />
              <Mapping SourceColumn="J2ExpiryDate" DataSetColumn="J2ExpiryDate" />
              <Mapping SourceColumn="Remark1" DataSetColumn="Remark1" />
              <Mapping SourceColumn="Remark2" DataSetColumn="Remark2" />
              <Mapping SourceColumn="Remark3" DataSetColumn="Remark3" />
              <Mapping SourceColumn="Remark4" DataSetColumn="Remark4" />
              <Mapping SourceColumn="Remark5" DataSetColumn="Remark5" />
              <Mapping SourceColumn="Remark6" DataSetColumn="Remark6" />
              <Mapping SourceColumn="VehicleMissionStatus" DataSetColumn="VehicleMissionStatus" />
              <Mapping SourceColumn="VehicleQCStatus" DataSetColumn="VehicleQCStatus" />
              <Mapping SourceColumn="InsertedUser" DataSetColumn="InsertedUser" />
              <Mapping SourceColumn="InsertedDate" DataSetColumn="InsertedDate" />
              <Mapping SourceColumn="UpdatedUser" DataSetColumn="UpdatedUser" />
              <Mapping SourceColumn="UpdatedDate" DataSetColumn="UpdatedDate" />
              <Mapping SourceColumn="DataVersion" DataSetColumn="DataVersion" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MissionManifestTableAdapter" GeneratorDataComponentClassName="MissionManifestTableAdapter" Name="MissionManifest" UserDataComponentName="MissionManifestTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoreBizDBConnectionString (Web.config)" DbObjectName="CoreBizDB.HeavyLift.ssrs_MissionManifest_GetByID" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>HeavyLift.ssrs_MissionManifest_GetByID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@MissionID" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MissionID" DataSetColumn="MissionID" />
              <Mapping SourceColumn="TMR" DataSetColumn="TMR" />
              <Mapping SourceColumn="MissionDate" DataSetColumn="MissionDate" />
              <Mapping SourceColumn="MissionTypeCode" DataSetColumn="MissionTypeCode" />
              <Mapping SourceColumn="MissionNumber" DataSetColumn="MissionNumber" />
              <Mapping SourceColumn="MissionStatusCode" DataSetColumn="MissionStatusCode" />
              <Mapping SourceColumn="EscortingUnitCode" DataSetColumn="EscortingUnitCode" />
              <Mapping SourceColumn="EscortingUnitPOC" DataSetColumn="EscortingUnitPOC" />
              <Mapping SourceColumn="EscortingUnitTEL" DataSetColumn="EscortingUnitTEL" />
              <Mapping SourceColumn="RequestingUnitCode" DataSetColumn="RequestingUnitCode" />
              <Mapping SourceColumn="RequestingUnitPOC" DataSetColumn="RequestingUnitPOC" />
              <Mapping SourceColumn="RequestingUnitTEL" DataSetColumn="RequestingUnitTEL" />
              <Mapping SourceColumn="DaysOfRation" DataSetColumn="DaysOfRation" />
              <Mapping SourceColumn="PushDateTime" DataSetColumn="PushDateTime" />
              <Mapping SourceColumn="DepartureDateTime" DataSetColumn="DepartureDateTime" />
              <Mapping SourceColumn="RollOutDateTime" DataSetColumn="RollOutDateTime" />
              <Mapping SourceColumn="NoofFB" DataSetColumn="NoofFB" />
              <Mapping SourceColumn="NoofFBBT" DataSetColumn="NoofFBBT" />
              <Mapping SourceColumn="NoofHET" DataSetColumn="NoofHET" />
              <Mapping SourceColumn="NoofHETBT" DataSetColumn="NoofHETBT" />
              <Mapping SourceColumn="NoofDrivers" DataSetColumn="NoofDrivers" />
              <Mapping SourceColumn="NoofACCs" DataSetColumn="NoofACCs" />
              <Mapping SourceColumn="AccCivilID" DataSetColumn="AccCivilID" />
              <Mapping SourceColumn="AccName" DataSetColumn="AccName" />
              <Mapping SourceColumn="AccTEL" DataSetColumn="AccTEL" />
              <Mapping SourceColumn="AccVehicleNumber" DataSetColumn="AccVehicleNumber" />
              <Mapping SourceColumn="MissionDetailID" DataSetColumn="MissionDetailID" />
              <Mapping SourceColumn="VehicleNumber" DataSetColumn="VehicleNumber" />
              <Mapping SourceColumn="LicensePlateNumber" DataSetColumn="LicensePlateNumber" />
              <Mapping SourceColumn="DriverNumber" DataSetColumn="DriverNumber" />
              <Mapping SourceColumn="DriverName" DataSetColumn="DriverName" />
              <Mapping SourceColumn="Nationality" DataSetColumn="Nationality" />
              <Mapping SourceColumn="PassportNumber" DataSetColumn="PassportNumber" />
              <Mapping SourceColumn="DriverCivilID" DataSetColumn="DriverCivilID" />
              <Mapping SourceColumn="VisaNumber" DataSetColumn="VisaNumber" />
              <Mapping SourceColumn="VisaExpiryDate" DataSetColumn="VisaExpiryDate" />
              <Mapping SourceColumn="LicenseExpiryDate" DataSetColumn="LicenseExpiryDate" />
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="TrailerNumber" DataSetColumn="TrailerNumber" />
              <Mapping SourceColumn="DepartureDate" DataSetColumn="DepartureDate" />
              <Mapping SourceColumn="DepartureRemarks" DataSetColumn="DepartureRemarks" />
              <Mapping SourceColumn="VehicleOutboundMilage" DataSetColumn="VehicleOutboundMilage" />
              <Mapping SourceColumn="DriverReturnDate" DataSetColumn="DriverReturnDate" />
              <Mapping SourceColumn="DriverReturnRemarks" DataSetColumn="DriverReturnRemarks" />
              <Mapping SourceColumn="AccomodationDate" DataSetColumn="AccomodationDate" />
              <Mapping SourceColumn="AccomodationRemarks" DataSetColumn="AccomodationRemarks" />
              <Mapping SourceColumn="VehicleReturnDate" DataSetColumn="VehicleReturnDate" />
              <Mapping SourceColumn="VehicleReturnRemarks" DataSetColumn="VehicleReturnRemarks" />
              <Mapping SourceColumn="VehicleInboundMilage" DataSetColumn="VehicleInboundMilage" />
              <Mapping SourceColumn="VehicleQCPassDate" DataSetColumn="VehicleQCPassDate" />
              <Mapping SourceColumn="VehicleQCPassRemarks" DataSetColumn="VehicleQCPassRemarks" />
              <Mapping SourceColumn="VehicleQCRejectedDate" DataSetColumn="VehicleQCRejectedDate" />
              <Mapping SourceColumn="VehicleQCRejectedRemarks" DataSetColumn="VehicleQCRejectedRemarks" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DriversAvailabilityStatusReportTableAdapter" GeneratorDataComponentClassName="DriversAvailabilityStatusReportTableAdapter" Name="DriversAvailabilityStatusReport" UserDataComponentName="DriversAvailabilityStatusReportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoreBizDBConnectionString (Web.config)" DbObjectName="CoreBizDB.HeavyLift.ssrs_DriversAvailabilityStatusReport" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>HeavyLift.ssrs_DriversAvailabilityStatusReport</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Availability" DataSetColumn="Availability" />
              <Mapping SourceColumn="Accomodation" DataSetColumn="Accomodation" />
              <Mapping SourceColumn="RestHours" DataSetColumn="RestHours" />
              <Mapping SourceColumn="EmployeeNo" DataSetColumn="EmployeeNo" />
              <Mapping SourceColumn="DriverName" DataSetColumn="DriverName" />
              <Mapping SourceColumn="DesignationCode" DataSetColumn="DesignationCode" />
              <Mapping SourceColumn="ShuaibaPassExpiryDate" DataSetColumn="ShuaibaPassExpiryDate" />
              <Mapping SourceColumn="J2SouthPassExpiry" DataSetColumn="J2SouthPassExpiry" />
              <Mapping SourceColumn="J2NorthPassExpiry" DataSetColumn="J2NorthPassExpiry" />
              <Mapping SourceColumn="Nationality" DataSetColumn="Nationality" />
              <Mapping SourceColumn="CivilID" DataSetColumn="CivilID" />
              <Mapping SourceColumn="PassportNo" DataSetColumn="PassportNo" />
              <Mapping SourceColumn="ResidencyNo" DataSetColumn="ResidencyNo" />
              <Mapping SourceColumn="CivilIDExpairyDate" DataSetColumn="CivilIDExpairyDate" />
              <Mapping SourceColumn="PassportDateOfExpiry" DataSetColumn="PassportDateOfExpiry" />
              <Mapping SourceColumn="DrivingLicenceExpiryDate" DataSetColumn="DrivingLicenceExpiryDate" />
              <Mapping SourceColumn="USFVirginiaBadgeNo" DataSetColumn="USFVirginiaBadgeNo" />
              <Mapping SourceColumn="USFVirginiaBadgeExpiry" DataSetColumn="USFVirginiaBadgeExpiry" />
              <Mapping SourceColumn="ASGKUBadgeNo" DataSetColumn="ASGKUBadgeNo" />
              <Mapping SourceColumn="ASGKUBadgeExpiry" DataSetColumn="ASGKUBadgeExpiry" />
              <Mapping SourceColumn="ShuaibaPassNo" DataSetColumn="ShuaibaPassNo" />
              <Mapping SourceColumn="TrainingRemark" DataSetColumn="TrainingRemark" />
              <Mapping SourceColumn="ViolationRemark" DataSetColumn="ViolationRemark" />
              <Mapping SourceColumn="Remark1" DataSetColumn="Remark1" />
              <Mapping SourceColumn="LastTMR" DataSetColumn="LastTMR" />
              <Mapping SourceColumn="DriverCivilID" DataSetColumn="DriverCivilID" />
              <Mapping SourceColumn="CumulativeWorkedHours" DataSetColumn="CumulativeWorkedHours" />
              <Mapping SourceColumn="LastRetunDate" DataSetColumn="LastRetunDate" />
              <Mapping SourceColumn="MissionType" DataSetColumn="MissionType" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MissionRollupReportTableAdapter" GeneratorDataComponentClassName="MissionRollupReportTableAdapter" Name="MissionRollupReport" UserDataComponentName="MissionRollupReportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoreBizDBConnectionString (Web.config)" DbObjectName="CoreBizDB.HeavyLift.ssrs_MissionRollup_GetByDate" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="FillByDate" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetDataByDate" GeneratorSourceName="FillByDate" GetMethodModifier="Public" GetMethodName="GetDataByDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetDataByDate" UserSourceName="FillByDate">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>HeavyLift.ssrs_MissionRollup_GetByDate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@MissionDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MissionID" DataSetColumn="MissionID" />
              <Mapping SourceColumn="MissionNumber" DataSetColumn="MissionNumber" />
              <Mapping SourceColumn="TMR" DataSetColumn="TMR" />
              <Mapping SourceColumn="NoofHET" DataSetColumn="NoofHET" />
              <Mapping SourceColumn="NoofHETBT" DataSetColumn="NoofHETBT" />
              <Mapping SourceColumn="NoofFB" DataSetColumn="NoofFB" />
              <Mapping SourceColumn="NoofFBBT" DataSetColumn="NoofFBBT" />
              <Mapping SourceColumn="MissionDate" DataSetColumn="MissionDate" />
              <Mapping SourceColumn="RollOutDateTime" DataSetColumn="RollOutDateTime" />
              <Mapping SourceColumn="Origin" DataSetColumn="Origin" />
              <Mapping SourceColumn="Destination" DataSetColumn="Destination" />
              <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
              <Mapping SourceColumn="CompanyCode" DataSetColumn="CompanyCode" />
              <Mapping SourceColumn="MissionTypeDescription" DataSetColumn="MissionTypeDescription" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MissionDetailsReportTableAdapter" GeneratorDataComponentClassName="MissionDetailsReportTableAdapter" Name="MissionDetailsReport" UserDataComponentName="MissionDetailsReportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoreBizDBConnectionString (Web.config)" DbObjectName="CoreBizDB.dbo.ssrs_MissionDetailsReport" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ssrs_MissionDetailsReport</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@MissionStatusType" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@FromDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@ToDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DriverName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CivilID" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@PassportNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@VehicleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@PlateNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MissionDetailID" DataSetColumn="MissionDetailID" />
              <Mapping SourceColumn="MissionID" DataSetColumn="MissionID" />
              <Mapping SourceColumn="VehicleNumber" DataSetColumn="VehicleNumber" />
              <Mapping SourceColumn="LicensePlateNumber" DataSetColumn="LicensePlateNumber" />
              <Mapping SourceColumn="DriverNumber" DataSetColumn="DriverNumber" />
              <Mapping SourceColumn="DriverName" DataSetColumn="DriverName" />
              <Mapping SourceColumn="Nationality" DataSetColumn="Nationality" />
              <Mapping SourceColumn="PassportNumber" DataSetColumn="PassportNumber" />
              <Mapping SourceColumn="DriverCivilID" DataSetColumn="DriverCivilID" />
              <Mapping SourceColumn="VisaNumber" DataSetColumn="VisaNumber" />
              <Mapping SourceColumn="VisaExpiryDate" DataSetColumn="VisaExpiryDate" />
              <Mapping SourceColumn="LicenseExpiryDate" DataSetColumn="LicenseExpiryDate" />
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="TrailerNumber" DataSetColumn="TrailerNumber" />
              <Mapping SourceColumn="DepartureDate" DataSetColumn="DepartureDate" />
              <Mapping SourceColumn="DepartureRemarks" DataSetColumn="DepartureRemarks" />
              <Mapping SourceColumn="VehicleOutboundMilage" DataSetColumn="VehicleOutboundMilage" />
              <Mapping SourceColumn="DriverReturnDate" DataSetColumn="DriverReturnDate" />
              <Mapping SourceColumn="DriverReturnRemarks" DataSetColumn="DriverReturnRemarks" />
              <Mapping SourceColumn="AccomodationDate" DataSetColumn="AccomodationDate" />
              <Mapping SourceColumn="AccomodationRemarks" DataSetColumn="AccomodationRemarks" />
              <Mapping SourceColumn="VehicleReturnDate" DataSetColumn="VehicleReturnDate" />
              <Mapping SourceColumn="VehicleReturnRemarks" DataSetColumn="VehicleReturnRemarks" />
              <Mapping SourceColumn="VehicleInboundMilage" DataSetColumn="VehicleInboundMilage" />
              <Mapping SourceColumn="VehicleQCPassDate" DataSetColumn="VehicleQCPassDate" />
              <Mapping SourceColumn="VehicleQCPassRemarks" DataSetColumn="VehicleQCPassRemarks" />
              <Mapping SourceColumn="VehicleQCRejectedDate" DataSetColumn="VehicleQCRejectedDate" />
              <Mapping SourceColumn="VehicleQCRejectedRemarks" DataSetColumn="VehicleQCRejectedRemarks" />
              <Mapping SourceColumn="InsertedUser" DataSetColumn="InsertedUser" />
              <Mapping SourceColumn="InsertedDate" DataSetColumn="InsertedDate" />
              <Mapping SourceColumn="UpdatedUser" DataSetColumn="UpdatedUser" />
              <Mapping SourceColumn="UpdatedDate" DataSetColumn="UpdatedDate" />
              <Mapping SourceColumn="DataVersion" DataSetColumn="DataVersion" />
              <Mapping SourceColumn="MissionID1" DataSetColumn="MissionID1" />
              <Mapping SourceColumn="TMR" DataSetColumn="TMR" />
              <Mapping SourceColumn="MissionDate" DataSetColumn="MissionDate" />
              <Mapping SourceColumn="MissionTypeCode" DataSetColumn="MissionTypeCode" />
              <Mapping SourceColumn="MissionNumber" DataSetColumn="MissionNumber" />
              <Mapping SourceColumn="MissionStatusCode" DataSetColumn="MissionStatusCode" />
              <Mapping SourceColumn="EscortingUnitCode" DataSetColumn="EscortingUnitCode" />
              <Mapping SourceColumn="EscortingUnitPOC" DataSetColumn="EscortingUnitPOC" />
              <Mapping SourceColumn="EscortingUnitTEL" DataSetColumn="EscortingUnitTEL" />
              <Mapping SourceColumn="RequestingUnitCode" DataSetColumn="RequestingUnitCode" />
              <Mapping SourceColumn="RequestingUnitPOC" DataSetColumn="RequestingUnitPOC" />
              <Mapping SourceColumn="RequestingUnitTEL" DataSetColumn="RequestingUnitTEL" />
              <Mapping SourceColumn="DaysOfRation" DataSetColumn="DaysOfRation" />
              <Mapping SourceColumn="PushDateTime" DataSetColumn="PushDateTime" />
              <Mapping SourceColumn="DepartureDateTime" DataSetColumn="DepartureDateTime" />
              <Mapping SourceColumn="RollOutDateTime" DataSetColumn="RollOutDateTime" />
              <Mapping SourceColumn="NoofFB" DataSetColumn="NoofFB" />
              <Mapping SourceColumn="NoofFBBT" DataSetColumn="NoofFBBT" />
              <Mapping SourceColumn="NoofHET" DataSetColumn="NoofHET" />
              <Mapping SourceColumn="NoofHETBT" DataSetColumn="NoofHETBT" />
              <Mapping SourceColumn="NoofDrivers" DataSetColumn="NoofDrivers" />
              <Mapping SourceColumn="NoofACCs" DataSetColumn="NoofACCs" />
              <Mapping SourceColumn="CompanyCode" DataSetColumn="CompanyCode" />
              <Mapping SourceColumn="AccCivilID" DataSetColumn="AccCivilID" />
              <Mapping SourceColumn="AccName" DataSetColumn="AccName" />
              <Mapping SourceColumn="AccTEL" DataSetColumn="AccTEL" />
              <Mapping SourceColumn="AccVehicleNumber" DataSetColumn="AccVehicleNumber" />
              <Mapping SourceColumn="Origin" DataSetColumn="Origin" />
              <Mapping SourceColumn="Destination" DataSetColumn="Destination" />
              <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
              <Mapping SourceColumn="InsertedUser1" DataSetColumn="InsertedUser1" />
              <Mapping SourceColumn="InsertedDate1" DataSetColumn="InsertedDate1" />
              <Mapping SourceColumn="UpdatedUser1" DataSetColumn="UpdatedUser1" />
              <Mapping SourceColumn="UpdatedDate1" DataSetColumn="UpdatedDate1" />
              <Mapping SourceColumn="DataVersion1" DataSetColumn="DataVersion1" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AvailabilityReportTableAdapter" GeneratorDataComponentClassName="AvailabilityReportTableAdapter" Name="AvailabilityReport" UserDataComponentName="AvailabilityReportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoreBizDBConnectionString (Web.config)" DbObjectName="CoreBizDB.HeavyLift.ssrs_AvailabilityReport" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>HeavyLift.ssrs_AvailabilityReport</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CompanyName" DataSetColumn="CompanyName" />
              <Mapping SourceColumn="MissionStatus" DataSetColumn="MissionStatus" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="Count" DataSetColumn="Count" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MissionRequestReportTableAdapter" GeneratorDataComponentClassName="MissionRequestReportTableAdapter" Name="MissionRequestReport" UserDataComponentName="MissionRequestReportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoreBizDBConnectionString (Web.config)" DbObjectName="CoreBizDB.HeavyLift.ssrs_MissionRequestReport" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>HeavyLift.ssrs_MissionRequestReport</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@FromDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@ToDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CompanyName" DataSetColumn="CompanyName" />
              <Mapping SourceColumn="MissionDate" DataSetColumn="MissionDate" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="Count" DataSetColumn="Count" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PayrollReportTableAdapter" GeneratorDataComponentClassName="PayrollReportTableAdapter" Name="PayrollReport" UserDataComponentName="PayrollReportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoreBizDBConnectionString (Web.config)" DbObjectName="CoreBizDB.HeavyLift.ssrs_PayrollReport" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>HeavyLift.ssrs_PayrollReport</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@FromDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@ToDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DriverName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CivilID" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@PassportNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EmployeeNo" DataSetColumn="EmployeeNo" />
              <Mapping SourceColumn="CivilID" DataSetColumn="CivilID" />
              <Mapping SourceColumn="DriverName" DataSetColumn="DriverName" />
              <Mapping SourceColumn="NoOfTrips" DataSetColumn="NoOfTrips" />
              <Mapping SourceColumn="TotalNoofDays" DataSetColumn="TotalNoofDays" />
              <Mapping SourceColumn="TotalNumberOfMilage" DataSetColumn="TotalNumberOfMilage" />
              <Mapping SourceColumn="TotalDayOfSick" DataSetColumn="TotalDayOfSick" />
              <Mapping SourceColumn="ViolationCount" DataSetColumn="ViolationCount" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TMRMilageReportTableAdapter" GeneratorDataComponentClassName="TMRMilageReportTableAdapter" Name="TMRMilageReport" UserDataComponentName="TMRMilageReportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoreBizDBConnectionString (Web.config)" DbObjectName="CoreBizDB.HeavyLift.ssrs_TMRMilageReport" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>HeavyLift.ssrs_TMRMilageReport</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@FromDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@ToDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@TMR" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MissionDate" DataSetColumn="MissionDate" />
              <Mapping SourceColumn="InboundDate" DataSetColumn="InboundDate" />
              <Mapping SourceColumn="TMR" DataSetColumn="TMR" />
              <Mapping SourceColumn="TotalRequest" DataSetColumn="TotalRequest" />
              <Mapping SourceColumn="AvgDuration" DataSetColumn="AvgDuration" />
              <Mapping SourceColumn="AvgMilage" DataSetColumn="AvgMilage" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="YardCountReportTableAdapter" GeneratorDataComponentClassName="YardCountReportTableAdapter" Name="YardCountReport" UserDataComponentName="YardCountReportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoreBizDBConnectionString (Web.config)" DbObjectName="CoreBizDB.HeavyLift.ssrs_YardCountReport" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>HeavyLift.ssrs_YardCountReport</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MissionStatus" DataSetColumn="MissionStatus" />
              <Mapping SourceColumn="TruckCount" DataSetColumn="TruckCount" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CoreBizDBDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="CoreBizDBDataSet" msprop:Generator_UserDSName="CoreBizDBDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Drivers" msprop:Generator_TableClassName="DriversDataTable" msprop:Generator_TableVarName="tableDrivers" msprop:Generator_TablePropName="Drivers" msprop:Generator_RowDeletingName="DriversRowDeleting" msprop:Generator_UserTableName="Drivers" msprop:Generator_RowChangingName="DriversRowChanging" msprop:Generator_RowEvHandlerName="DriversRowChangeEventHandler" msprop:Generator_RowDeletedName="DriversRowDeleted" msprop:Generator_RowEvArgName="DriversRowChangeEvent" msprop:Generator_RowChangedName="DriversRowChanged" msprop:Generator_RowClassName="DriversRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CivilID" msprop:Generator_ColumnVarNameInTable="columnCivilID" msprop:Generator_ColumnPropNameInRow="CivilID" msprop:Generator_ColumnPropNameInTable="CivilIDColumn" msprop:Generator_UserColumnName="CivilID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MiddleName" msprop:Generator_ColumnVarNameInTable="columnMiddleName" msprop:Generator_ColumnPropNameInRow="MiddleName" msprop:Generator_ColumnPropNameInTable="MiddleNameColumn" msprop:Generator_UserColumnName="MiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArabicFirstName" msprop:Generator_ColumnVarNameInTable="columnArabicFirstName" msprop:Generator_ColumnPropNameInRow="ArabicFirstName" msprop:Generator_ColumnPropNameInTable="ArabicFirstNameColumn" msprop:Generator_UserColumnName="ArabicFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArabicMiddleName" msprop:Generator_ColumnVarNameInTable="columnArabicMiddleName" msprop:Generator_ColumnPropNameInRow="ArabicMiddleName" msprop:Generator_ColumnPropNameInTable="ArabicMiddleNameColumn" msprop:Generator_UserColumnName="ArabicMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArabicLastName" msprop:Generator_ColumnVarNameInTable="columnArabicLastName" msprop:Generator_ColumnPropNameInRow="ArabicLastName" msprop:Generator_ColumnPropNameInTable="ArabicLastNameColumn" msprop:Generator_UserColumnName="ArabicLastName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn" msprop:Generator_UserColumnName="CountryCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateOfBirth" msprop:Generator_ColumnVarNameInTable="columnDateOfBirth" msprop:Generator_ColumnPropNameInRow="DateOfBirth" msprop:Generator_ColumnPropNameInTable="DateOfBirthColumn" msprop:Generator_UserColumnName="DateOfBirth" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Age" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAge" msprop:Generator_ColumnPropNameInRow="Age" msprop:Generator_ColumnPropNameInTable="AgeColumn" msprop:Generator_UserColumnName="Age" type="xs:int" minOccurs="0" />
              <xs:element name="SpouseName" msprop:Generator_ColumnVarNameInTable="columnSpouseName" msprop:Generator_ColumnPropNameInRow="SpouseName" msprop:Generator_ColumnPropNameInTable="SpouseNameColumn" msprop:Generator_UserColumnName="SpouseName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="450" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FathersName" msprop:Generator_ColumnVarNameInTable="columnFathersName" msprop:Generator_ColumnPropNameInRow="FathersName" msprop:Generator_ColumnPropNameInTable="FathersNameColumn" msprop:Generator_UserColumnName="FathersName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="450" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GrandFathersName" msprop:Generator_ColumnVarNameInTable="columnGrandFathersName" msprop:Generator_ColumnPropNameInRow="GrandFathersName" msprop:Generator_ColumnPropNameInTable="GrandFathersNameColumn" msprop:Generator_UserColumnName="GrandFathersName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="450" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GrandMothersName" msprop:Generator_ColumnVarNameInTable="columnGrandMothersName" msprop:Generator_ColumnPropNameInRow="GrandMothersName" msprop:Generator_ColumnPropNameInTable="GrandMothersNameColumn" msprop:Generator_UserColumnName="GrandMothersName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="450" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MothersName" msprop:Generator_ColumnVarNameInTable="columnMothersName" msprop:Generator_ColumnPropNameInRow="MothersName" msprop:Generator_ColumnPropNameInTable="MothersNameColumn" msprop:Generator_UserColumnName="MothersName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="450" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MothersFatherName" msprop:Generator_ColumnVarNameInTable="columnMothersFatherName" msprop:Generator_ColumnPropNameInRow="MothersFatherName" msprop:Generator_ColumnPropNameInTable="MothersFatherNameColumn" msprop:Generator_UserColumnName="MothersFatherName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="450" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MartialStatus" msprop:Generator_ColumnVarNameInTable="columnMartialStatus" msprop:Generator_ColumnPropNameInRow="MartialStatus" msprop:Generator_ColumnPropNameInTable="MartialStatusColumn" msprop:Generator_UserColumnName="MartialStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CityOfBirth" msprop:Generator_ColumnVarNameInTable="columnCityOfBirth" msprop:Generator_ColumnPropNameInRow="CityOfBirth" msprop:Generator_ColumnPropNameInTable="CityOfBirthColumn" msprop:Generator_UserColumnName="CityOfBirth" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PlaceOfBirth" msprop:Generator_ColumnVarNameInTable="columnPlaceOfBirth" msprop:Generator_ColumnPropNameInRow="PlaceOfBirth" msprop:Generator_ColumnPropNameInTable="PlaceOfBirthColumn" msprop:Generator_UserColumnName="PlaceOfBirth" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EyeColor" msprop:Generator_ColumnVarNameInTable="columnEyeColor" msprop:Generator_ColumnPropNameInRow="EyeColor" msprop:Generator_ColumnPropNameInTable="EyeColorColumn" msprop:Generator_UserColumnName="EyeColor" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HairColor" msprop:Generator_ColumnVarNameInTable="columnHairColor" msprop:Generator_ColumnPropNameInRow="HairColor" msprop:Generator_ColumnPropNameInTable="HairColorColumn" msprop:Generator_UserColumnName="HairColor" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HeightInCM" msprop:Generator_ColumnVarNameInTable="columnHeightInCM" msprop:Generator_ColumnPropNameInRow="HeightInCM" msprop:Generator_ColumnPropNameInTable="HeightInCMColumn" msprop:Generator_UserColumnName="HeightInCM" type="xs:decimal" minOccurs="0" />
              <xs:element name="HeightInFeet" msprop:Generator_ColumnVarNameInTable="columnHeightInFeet" msprop:Generator_ColumnPropNameInRow="HeightInFeet" msprop:Generator_ColumnPropNameInTable="HeightInFeetColumn" msprop:Generator_UserColumnName="HeightInFeet" type="xs:decimal" minOccurs="0" />
              <xs:element name="WeightInKG" msprop:Generator_ColumnVarNameInTable="columnWeightInKG" msprop:Generator_ColumnPropNameInRow="WeightInKG" msprop:Generator_ColumnPropNameInTable="WeightInKGColumn" msprop:Generator_UserColumnName="WeightInKG" type="xs:decimal" minOccurs="0" />
              <xs:element name="WeightInLbs" msprop:Generator_ColumnVarNameInTable="columnWeightInLbs" msprop:Generator_ColumnPropNameInRow="WeightInLbs" msprop:Generator_ColumnPropNameInTable="WeightInLbsColumn" msprop:Generator_UserColumnName="WeightInLbs" type="xs:decimal" minOccurs="0" />
              <xs:element name="Race" msprop:Generator_ColumnVarNameInTable="columnRace" msprop:Generator_ColumnPropNameInRow="Race" msprop:Generator_ColumnPropNameInTable="RaceColumn" msprop:Generator_UserColumnName="Race" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Religion" msprop:Generator_ColumnVarNameInTable="columnReligion" msprop:Generator_ColumnPropNameInRow="Religion" msprop:Generator_ColumnPropNameInTable="ReligionColumn" msprop:Generator_UserColumnName="Religion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BloodGroup" msprop:Generator_ColumnVarNameInTable="columnBloodGroup" msprop:Generator_ColumnPropNameInRow="BloodGroup" msprop:Generator_ColumnPropNameInTable="BloodGroupColumn" msprop:Generator_UserColumnName="BloodGroup" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PermanentAddess" msprop:Generator_ColumnVarNameInTable="columnPermanentAddess" msprop:Generator_ColumnPropNameInRow="PermanentAddess" msprop:Generator_ColumnPropNameInTable="PermanentAddessColumn" msprop:Generator_UserColumnName="PermanentAddess" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LocalAddress" msprop:Generator_ColumnVarNameInTable="columnLocalAddress" msprop:Generator_ColumnPropNameInRow="LocalAddress" msprop:Generator_ColumnPropNameInTable="LocalAddressColumn" msprop:Generator_UserColumnName="LocalAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Education" msprop:Generator_ColumnVarNameInTable="columnEducation" msprop:Generator_ColumnPropNameInRow="Education" msprop:Generator_ColumnPropNameInTable="EducationColumn" msprop:Generator_UserColumnName="Education" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Specialization" msprop:Generator_ColumnVarNameInTable="columnSpecialization" msprop:Generator_ColumnPropNameInRow="Specialization" msprop:Generator_ColumnPropNameInTable="SpecializationColumn" msprop:Generator_UserColumnName="Specialization" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Photo" msprop:Generator_ColumnVarNameInTable="columnPhoto" msprop:Generator_ColumnPropNameInRow="Photo" msprop:Generator_ColumnPropNameInTable="PhotoColumn" msprop:Generator_UserColumnName="Photo" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="SocialSecurityNo" msprop:Generator_ColumnVarNameInTable="columnSocialSecurityNo" msprop:Generator_ColumnPropNameInRow="SocialSecurityNo" msprop:Generator_ColumnPropNameInTable="SocialSecurityNoColumn" msprop:Generator_UserColumnName="SocialSecurityNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PassportNo" msprop:Generator_ColumnVarNameInTable="columnPassportNo" msprop:Generator_ColumnPropNameInRow="PassportNo" msprop:Generator_ColumnPropNameInTable="PassportNoColumn" msprop:Generator_UserColumnName="PassportNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PassportDateOfIssue" msprop:Generator_ColumnVarNameInTable="columnPassportDateOfIssue" msprop:Generator_ColumnPropNameInRow="PassportDateOfIssue" msprop:Generator_ColumnPropNameInTable="PassportDateOfIssueColumn" msprop:Generator_UserColumnName="PassportDateOfIssue" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PassportDateOfExpiry" msprop:Generator_ColumnVarNameInTable="columnPassportDateOfExpiry" msprop:Generator_ColumnPropNameInRow="PassportDateOfExpiry" msprop:Generator_ColumnPropNameInTable="PassportDateOfExpiryColumn" msprop:Generator_UserColumnName="PassportDateOfExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PassportPlaceOfIssue" msprop:Generator_ColumnVarNameInTable="columnPassportPlaceOfIssue" msprop:Generator_ColumnPropNameInRow="PassportPlaceOfIssue" msprop:Generator_ColumnPropNameInTable="PassportPlaceOfIssueColumn" msprop:Generator_UserColumnName="PassportPlaceOfIssue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MasterListNo" msprop:Generator_ColumnVarNameInTable="columnMasterListNo" msprop:Generator_ColumnPropNameInRow="MasterListNo" msprop:Generator_ColumnPropNameInTable="MasterListNoColumn" msprop:Generator_UserColumnName="MasterListNo" type="xs:int" minOccurs="0" />
              <xs:element name="EmployeeNo" msprop:Generator_ColumnVarNameInTable="columnEmployeeNo" msprop:Generator_ColumnPropNameInRow="EmployeeNo" msprop:Generator_ColumnPropNameInTable="EmployeeNoColumn" msprop:Generator_UserColumnName="EmployeeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ExternalEmployeeNo" msprop:Generator_ColumnVarNameInTable="columnExternalEmployeeNo" msprop:Generator_ColumnPropNameInRow="ExternalEmployeeNo" msprop:Generator_ColumnPropNameInTable="ExternalEmployeeNoColumn" msprop:Generator_UserColumnName="ExternalEmployeeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ExtensionNo" msprop:Generator_ColumnVarNameInTable="columnExtensionNo" msprop:Generator_ColumnPropNameInRow="ExtensionNo" msprop:Generator_ColumnPropNameInTable="ExtensionNoColumn" msprop:Generator_UserColumnName="ExtensionNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FaxNo" msprop:Generator_ColumnVarNameInTable="columnFaxNo" msprop:Generator_ColumnPropNameInRow="FaxNo" msprop:Generator_ColumnPropNameInTable="FaxNoColumn" msprop:Generator_UserColumnName="FaxNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NextOfKin" msprop:Generator_ColumnVarNameInTable="columnNextOfKin" msprop:Generator_ColumnPropNameInRow="NextOfKin" msprop:Generator_ColumnPropNameInTable="NextOfKinColumn" msprop:Generator_UserColumnName="NextOfKin" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KinRelationship" msprop:Generator_ColumnVarNameInTable="columnKinRelationship" msprop:Generator_ColumnPropNameInRow="KinRelationship" msprop:Generator_ColumnPropNameInTable="KinRelationshipColumn" msprop:Generator_UserColumnName="KinRelationship" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KinContactNo" msprop:Generator_ColumnVarNameInTable="columnKinContactNo" msprop:Generator_ColumnPropNameInRow="KinContactNo" msprop:Generator_ColumnPropNameInTable="KinContactNoColumn" msprop:Generator_UserColumnName="KinContactNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KinNativelLanguage" msprop:Generator_ColumnVarNameInTable="columnKinNativelLanguage" msprop:Generator_ColumnPropNameInRow="KinNativelLanguage" msprop:Generator_ColumnPropNameInTable="KinNativelLanguageColumn" msprop:Generator_UserColumnName="KinNativelLanguage" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DepartmentCode" msprop:Generator_ColumnVarNameInTable="columnDepartmentCode" msprop:Generator_ColumnPropNameInRow="DepartmentCode" msprop:Generator_ColumnPropNameInTable="DepartmentCodeColumn" msprop:Generator_UserColumnName="DepartmentCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DesignationCode" msprop:Generator_ColumnVarNameInTable="columnDesignationCode" msprop:Generator_ColumnPropNameInRow="DesignationCode" msprop:Generator_ColumnPropNameInTable="DesignationCodeColumn" msprop:Generator_UserColumnName="DesignationCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CompanyCode" msprop:Generator_ColumnVarNameInTable="columnCompanyCode" msprop:Generator_ColumnPropNameInRow="CompanyCode" msprop:Generator_ColumnPropNameInTable="CompanyCodeColumn" msprop:Generator_UserColumnName="CompanyCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DesignationArabic" msprop:Generator_ColumnVarNameInTable="columnDesignationArabic" msprop:Generator_ColumnPropNameInRow="DesignationArabic" msprop:Generator_ColumnPropNameInTable="DesignationArabicColumn" msprop:Generator_UserColumnName="DesignationArabic" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LeaveEntitled" msprop:Generator_ColumnVarNameInTable="columnLeaveEntitled" msprop:Generator_ColumnPropNameInRow="LeaveEntitled" msprop:Generator_ColumnPropNameInTable="LeaveEntitledColumn" msprop:Generator_UserColumnName="LeaveEntitled" type="xs:int" minOccurs="0" />
              <xs:element name="LeaveAccrued" msprop:Generator_ColumnVarNameInTable="columnLeaveAccrued" msprop:Generator_ColumnPropNameInRow="LeaveAccrued" msprop:Generator_ColumnPropNameInTable="LeaveAccruedColumn" msprop:Generator_UserColumnName="LeaveAccrued" type="xs:int" minOccurs="0" />
              <xs:element name="AccomodationCode" msprop:Generator_ColumnVarNameInTable="columnAccomodationCode" msprop:Generator_ColumnPropNameInRow="AccomodationCode" msprop:Generator_ColumnPropNameInTable="AccomodationCodeColumn" msprop:Generator_UserColumnName="AccomodationCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PayByCash" msprop:Generator_ColumnVarNameInTable="columnPayByCash" msprop:Generator_ColumnPropNameInRow="PayByCash" msprop:Generator_ColumnPropNameInTable="PayByCashColumn" msprop:Generator_UserColumnName="PayByCash" type="xs:boolean" minOccurs="0" />
              <xs:element name="BankName" msprop:Generator_ColumnVarNameInTable="columnBankName" msprop:Generator_ColumnPropNameInRow="BankName" msprop:Generator_ColumnPropNameInTable="BankNameColumn" msprop:Generator_UserColumnName="BankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BankAccountNo" msprop:Generator_ColumnVarNameInTable="columnBankAccountNo" msprop:Generator_ColumnPropNameInRow="BankAccountNo" msprop:Generator_ColumnPropNameInTable="BankAccountNoColumn" msprop:Generator_UserColumnName="BankAccountNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ExpectedDateOfJoining" msprop:Generator_ColumnVarNameInTable="columnExpectedDateOfJoining" msprop:Generator_ColumnPropNameInRow="ExpectedDateOfJoining" msprop:Generator_ColumnPropNameInTable="ExpectedDateOfJoiningColumn" msprop:Generator_UserColumnName="ExpectedDateOfJoining" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DateOfJoining" msprop:Generator_ColumnVarNameInTable="columnDateOfJoining" msprop:Generator_ColumnPropNameInRow="DateOfJoining" msprop:Generator_ColumnPropNameInTable="DateOfJoiningColumn" msprop:Generator_UserColumnName="DateOfJoining" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ResidencyNo" msprop:Generator_ColumnVarNameInTable="columnResidencyNo" msprop:Generator_ColumnPropNameInRow="ResidencyNo" msprop:Generator_ColumnPropNameInTable="ResidencyNoColumn" msprop:Generator_UserColumnName="ResidencyNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ResidencyExpairyDate" msprop:Generator_ColumnVarNameInTable="columnResidencyExpairyDate" msprop:Generator_ColumnPropNameInRow="ResidencyExpairyDate" msprop:Generator_ColumnPropNameInTable="ResidencyExpairyDateColumn" msprop:Generator_UserColumnName="ResidencyExpairyDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CivilIDExpairyDate" msprop:Generator_ColumnVarNameInTable="columnCivilIDExpairyDate" msprop:Generator_ColumnPropNameInRow="CivilIDExpairyDate" msprop:Generator_ColumnPropNameInTable="CivilIDExpairyDateColumn" msprop:Generator_UserColumnName="CivilIDExpairyDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DrivingLicenceNo" msprop:Generator_ColumnVarNameInTable="columnDrivingLicenceNo" msprop:Generator_ColumnPropNameInRow="DrivingLicenceNo" msprop:Generator_ColumnPropNameInTable="DrivingLicenceNoColumn" msprop:Generator_UserColumnName="DrivingLicenceNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DrivingLicenceExpiryDate" msprop:Generator_ColumnVarNameInTable="columnDrivingLicenceExpiryDate" msprop:Generator_ColumnPropNameInRow="DrivingLicenceExpiryDate" msprop:Generator_ColumnPropNameInTable="DrivingLicenceExpiryDateColumn" msprop:Generator_UserColumnName="DrivingLicenceExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ShuaibaPassNo" msprop:Generator_ColumnVarNameInTable="columnShuaibaPassNo" msprop:Generator_ColumnPropNameInRow="ShuaibaPassNo" msprop:Generator_ColumnPropNameInTable="ShuaibaPassNoColumn" msprop:Generator_UserColumnName="ShuaibaPassNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShuaibaPassExpiryDate" msprop:Generator_ColumnVarNameInTable="columnShuaibaPassExpiryDate" msprop:Generator_ColumnPropNameInRow="ShuaibaPassExpiryDate" msprop:Generator_ColumnPropNameInTable="ShuaibaPassExpiryDateColumn" msprop:Generator_UserColumnName="ShuaibaPassExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ShuaibaPassRemarks" msprop:Generator_ColumnVarNameInTable="columnShuaibaPassRemarks" msprop:Generator_ColumnPropNameInRow="ShuaibaPassRemarks" msprop:Generator_ColumnPropNameInTable="ShuaibaPassRemarksColumn" msprop:Generator_UserColumnName="ShuaibaPassRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="J2SouthPassNo" msprop:Generator_ColumnVarNameInTable="columnJ2SouthPassNo" msprop:Generator_ColumnPropNameInRow="J2SouthPassNo" msprop:Generator_ColumnPropNameInTable="J2SouthPassNoColumn" msprop:Generator_UserColumnName="J2SouthPassNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="J2SouthPassExpiry" msprop:Generator_ColumnVarNameInTable="columnJ2SouthPassExpiry" msprop:Generator_ColumnPropNameInRow="J2SouthPassExpiry" msprop:Generator_ColumnPropNameInTable="J2SouthPassExpiryColumn" msprop:Generator_UserColumnName="J2SouthPassExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="J2SouthPassRemark" msprop:Generator_ColumnVarNameInTable="columnJ2SouthPassRemark" msprop:Generator_ColumnPropNameInRow="J2SouthPassRemark" msprop:Generator_ColumnPropNameInTable="J2SouthPassRemarkColumn" msprop:Generator_UserColumnName="J2SouthPassRemark" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="J2NorthPassNo" msprop:Generator_ColumnVarNameInTable="columnJ2NorthPassNo" msprop:Generator_ColumnPropNameInRow="J2NorthPassNo" msprop:Generator_ColumnPropNameInTable="J2NorthPassNoColumn" msprop:Generator_UserColumnName="J2NorthPassNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="J2NorthPassExpiry" msprop:Generator_ColumnVarNameInTable="columnJ2NorthPassExpiry" msprop:Generator_ColumnPropNameInRow="J2NorthPassExpiry" msprop:Generator_ColumnPropNameInTable="J2NorthPassExpiryColumn" msprop:Generator_UserColumnName="J2NorthPassExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="J2NorthPassRemarks" msprop:Generator_ColumnVarNameInTable="columnJ2NorthPassRemarks" msprop:Generator_ColumnPropNameInRow="J2NorthPassRemarks" msprop:Generator_ColumnPropNameInTable="J2NorthPassRemarksColumn" msprop:Generator_UserColumnName="J2NorthPassRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="USFVirginiaBadgeNo" msprop:Generator_ColumnVarNameInTable="columnUSFVirginiaBadgeNo" msprop:Generator_ColumnPropNameInRow="USFVirginiaBadgeNo" msprop:Generator_ColumnPropNameInTable="USFVirginiaBadgeNoColumn" msprop:Generator_UserColumnName="USFVirginiaBadgeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="USFVirginiaBadgeExpiry" msprop:Generator_ColumnVarNameInTable="columnUSFVirginiaBadgeExpiry" msprop:Generator_ColumnPropNameInRow="USFVirginiaBadgeExpiry" msprop:Generator_ColumnPropNameInTable="USFVirginiaBadgeExpiryColumn" msprop:Generator_UserColumnName="USFVirginiaBadgeExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="USFVirginiaBadgeRemarks" msprop:Generator_ColumnVarNameInTable="columnUSFVirginiaBadgeRemarks" msprop:Generator_ColumnPropNameInRow="USFVirginiaBadgeRemarks" msprop:Generator_ColumnPropNameInTable="USFVirginiaBadgeRemarksColumn" msprop:Generator_UserColumnName="USFVirginiaBadgeRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ASGKUBadgeNo" msprop:Generator_ColumnVarNameInTable="columnASGKUBadgeNo" msprop:Generator_ColumnPropNameInRow="ASGKUBadgeNo" msprop:Generator_ColumnPropNameInTable="ASGKUBadgeNoColumn" msprop:Generator_UserColumnName="ASGKUBadgeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ASGKUBadgeExpiry" msprop:Generator_ColumnVarNameInTable="columnASGKUBadgeExpiry" msprop:Generator_ColumnPropNameInRow="ASGKUBadgeExpiry" msprop:Generator_ColumnPropNameInTable="ASGKUBadgeExpiryColumn" msprop:Generator_UserColumnName="ASGKUBadgeExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ASGKUBadgeRemarks" msprop:Generator_ColumnVarNameInTable="columnASGKUBadgeRemarks" msprop:Generator_ColumnPropNameInRow="ASGKUBadgeRemarks" msprop:Generator_ColumnPropNameInTable="ASGKUBadgeRemarksColumn" msprop:Generator_UserColumnName="ASGKUBadgeRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrainingRemark" msprop:Generator_ColumnVarNameInTable="columnTrainingRemark" msprop:Generator_ColumnPropNameInRow="TrainingRemark" msprop:Generator_ColumnPropNameInTable="TrainingRemarkColumn" msprop:Generator_UserColumnName="TrainingRemark" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ViolationRemark" msprop:Generator_ColumnVarNameInTable="columnViolationRemark" msprop:Generator_ColumnPropNameInRow="ViolationRemark" msprop:Generator_ColumnPropNameInTable="ViolationRemarkColumn" msprop:Generator_UserColumnName="ViolationRemark" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccidentRemark" msprop:Generator_ColumnVarNameInTable="columnAccidentRemark" msprop:Generator_ColumnPropNameInRow="AccidentRemark" msprop:Generator_ColumnPropNameInTable="AccidentRemarkColumn" msprop:Generator_UserColumnName="AccidentRemark" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark1" msprop:Generator_ColumnVarNameInTable="columnRemark1" msprop:Generator_ColumnPropNameInRow="Remark1" msprop:Generator_ColumnPropNameInTable="Remark1Column" msprop:Generator_UserColumnName="Remark1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark2" msprop:Generator_ColumnVarNameInTable="columnRemark2" msprop:Generator_ColumnPropNameInRow="Remark2" msprop:Generator_ColumnPropNameInTable="Remark2Column" msprop:Generator_UserColumnName="Remark2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark3" msprop:Generator_ColumnVarNameInTable="columnRemark3" msprop:Generator_ColumnPropNameInRow="Remark3" msprop:Generator_ColumnPropNameInTable="Remark3Column" msprop:Generator_UserColumnName="Remark3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark4" msprop:Generator_ColumnVarNameInTable="columnRemark4" msprop:Generator_ColumnPropNameInRow="Remark4" msprop:Generator_ColumnPropNameInTable="Remark4Column" msprop:Generator_UserColumnName="Remark4" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark5" msprop:Generator_ColumnVarNameInTable="columnRemark5" msprop:Generator_ColumnPropNameInRow="Remark5" msprop:Generator_ColumnPropNameInTable="Remark5Column" msprop:Generator_UserColumnName="Remark5" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark6" msprop:Generator_ColumnVarNameInTable="columnRemark6" msprop:Generator_ColumnPropNameInRow="Remark6" msprop:Generator_ColumnPropNameInTable="Remark6Column" msprop:Generator_UserColumnName="Remark6" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriverMissionStatus" msprop:Generator_ColumnVarNameInTable="columnDriverMissionStatus" msprop:Generator_ColumnPropNameInRow="DriverMissionStatus" msprop:Generator_ColumnPropNameInTable="DriverMissionStatusColumn" msprop:Generator_UserColumnName="DriverMissionStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriverHRStatus" msprop:Generator_ColumnVarNameInTable="columnDriverHRStatus" msprop:Generator_ColumnPropNameInRow="DriverHRStatus" msprop:Generator_ColumnPropNameInTable="DriverHRStatusColumn" msprop:Generator_UserColumnName="DriverHRStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InsertedUser" msprop:Generator_ColumnVarNameInTable="columnInsertedUser" msprop:Generator_ColumnPropNameInRow="InsertedUser" msprop:Generator_ColumnPropNameInTable="InsertedUserColumn" msprop:Generator_UserColumnName="InsertedUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InsertedDate" msprop:Generator_ColumnVarNameInTable="columnInsertedDate" msprop:Generator_ColumnPropNameInRow="InsertedDate" msprop:Generator_ColumnPropNameInTable="InsertedDateColumn" msprop:Generator_UserColumnName="InsertedDate" type="xs:dateTime" />
              <xs:element name="UpdatedUser" msprop:Generator_ColumnVarNameInTable="columnUpdatedUser" msprop:Generator_ColumnPropNameInRow="UpdatedUser" msprop:Generator_ColumnPropNameInTable="UpdatedUserColumn" msprop:Generator_UserColumnName="UpdatedUser">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UpdatedDate" msprop:Generator_ColumnVarNameInTable="columnUpdatedDate" msprop:Generator_ColumnPropNameInRow="UpdatedDate" msprop:Generator_ColumnPropNameInTable="UpdatedDateColumn" msprop:Generator_UserColumnName="UpdatedDate" type="xs:dateTime" />
              <xs:element name="DataVersion" msprop:Generator_ColumnVarNameInTable="columnDataVersion" msprop:Generator_ColumnPropNameInRow="DataVersion" msprop:Generator_ColumnPropNameInTable="DataVersionColumn" msprop:Generator_UserColumnName="DataVersion" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Vehicles" msprop:Generator_TableClassName="VehiclesDataTable" msprop:Generator_TableVarName="tableVehicles" msprop:Generator_TablePropName="Vehicles" msprop:Generator_RowDeletingName="VehiclesRowDeleting" msprop:Generator_UserTableName="Vehicles" msprop:Generator_RowChangingName="VehiclesRowChanging" msprop:Generator_RowEvHandlerName="VehiclesRowChangeEventHandler" msprop:Generator_RowDeletedName="VehiclesRowDeleted" msprop:Generator_RowEvArgName="VehiclesRowChangeEvent" msprop:Generator_RowChangedName="VehiclesRowChanged" msprop:Generator_RowClassName="VehiclesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VehicleNumber" msprop:Generator_ColumnVarNameInTable="columnVehicleNumber" msprop:Generator_ColumnPropNameInRow="VehicleNumber" msprop:Generator_ColumnPropNameInTable="VehicleNumberColumn" msprop:Generator_UserColumnName="VehicleNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DoorNo" msprop:Generator_ColumnVarNameInTable="columnDoorNo" msprop:Generator_ColumnPropNameInRow="DoorNo" msprop:Generator_ColumnPropNameInTable="DoorNoColumn" msprop:Generator_UserColumnName="DoorNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LicensePlateNumber" msprop:Generator_ColumnVarNameInTable="columnLicensePlateNumber" msprop:Generator_ColumnPropNameInRow="LicensePlateNumber" msprop:Generator_ColumnPropNameInTable="LicensePlateNumberColumn" msprop:Generator_UserColumnName="LicensePlateNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VIN" msprop:Generator_ColumnVarNameInTable="columnVIN" msprop:Generator_ColumnPropNameInRow="VIN" msprop:Generator_ColumnPropNameInTable="VINColumn" msprop:Generator_UserColumnName="VIN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MasterListNo" msprop:Generator_ColumnVarNameInTable="columnMasterListNo" msprop:Generator_ColumnPropNameInRow="MasterListNo" msprop:Generator_ColumnPropNameInTable="MasterListNoColumn" msprop:Generator_UserColumnName="MasterListNo" type="xs:double" minOccurs="0" />
              <xs:element name="CompanyCode" msprop:Generator_ColumnVarNameInTable="columnCompanyCode" msprop:Generator_ColumnPropNameInRow="CompanyCode" msprop:Generator_ColumnPropNameInTable="CompanyCodeColumn" msprop:Generator_UserColumnName="CompanyCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BodyType" msprop:Generator_ColumnVarNameInTable="columnBodyType" msprop:Generator_ColumnPropNameInRow="BodyType" msprop:Generator_ColumnPropNameInTable="BodyTypeColumn" msprop:Generator_UserColumnName="BodyType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Make" msprop:Generator_ColumnVarNameInTable="columnMake" msprop:Generator_ColumnPropNameInRow="Make" msprop:Generator_ColumnPropNameInTable="MakeColumn" msprop:Generator_UserColumnName="Make" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnPropNameInTable="YearColumn" msprop:Generator_UserColumnName="Year" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Color" msprop:Generator_ColumnVarNameInTable="columnColor" msprop:Generator_ColumnPropNameInRow="Color" msprop:Generator_ColumnPropNameInTable="ColorColumn" msprop:Generator_UserColumnName="Color" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InsuranceCompany" msprop:Generator_ColumnVarNameInTable="columnInsuranceCompany" msprop:Generator_ColumnPropNameInRow="InsuranceCompany" msprop:Generator_ColumnPropNameInTable="InsuranceCompanyColumn" msprop:Generator_UserColumnName="InsuranceCompany" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InsuranceExpiryDate" msprop:Generator_ColumnVarNameInTable="columnInsuranceExpiryDate" msprop:Generator_ColumnPropNameInRow="InsuranceExpiryDate" msprop:Generator_ColumnPropNameInTable="InsuranceExpiryDateColumn" msprop:Generator_UserColumnName="InsuranceExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RegistrationExpiryDate" msprop:Generator_ColumnVarNameInTable="columnRegistrationExpiryDate" msprop:Generator_ColumnPropNameInRow="RegistrationExpiryDate" msprop:Generator_ColumnPropNameInTable="RegistrationExpiryDateColumn" msprop:Generator_UserColumnName="RegistrationExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AppsGivenDate" msprop:Generator_ColumnVarNameInTable="columnAppsGivenDate" msprop:Generator_ColumnPropNameInRow="AppsGivenDate" msprop:Generator_ColumnPropNameInTable="AppsGivenDateColumn" msprop:Generator_UserColumnName="AppsGivenDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ASGPassIssueDate" msprop:Generator_ColumnVarNameInTable="columnASGPassIssueDate" msprop:Generator_ColumnPropNameInRow="ASGPassIssueDate" msprop:Generator_ColumnPropNameInTable="ASGPassIssueDateColumn" msprop:Generator_UserColumnName="ASGPassIssueDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ASGPassExpiryDate" msprop:Generator_ColumnVarNameInTable="columnASGPassExpiryDate" msprop:Generator_ColumnPropNameInRow="ASGPassExpiryDate" msprop:Generator_ColumnPropNameInTable="ASGPassExpiryDateColumn" msprop:Generator_UserColumnName="ASGPassExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="TrailorNo" msprop:Generator_ColumnVarNameInTable="columnTrailorNo" msprop:Generator_ColumnPropNameInRow="TrailorNo" msprop:Generator_ColumnPropNameInTable="TrailorNoColumn" msprop:Generator_UserColumnName="TrailorNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KmIn" msprop:Generator_ColumnVarNameInTable="columnKmIn" msprop:Generator_ColumnPropNameInRow="KmIn" msprop:Generator_ColumnPropNameInTable="KmInColumn" msprop:Generator_UserColumnName="KmIn" type="xs:long" minOccurs="0" />
              <xs:element name="KmOut" msprop:Generator_ColumnVarNameInTable="columnKmOut" msprop:Generator_ColumnPropNameInRow="KmOut" msprop:Generator_ColumnPropNameInTable="KmOutColumn" msprop:Generator_UserColumnName="KmOut" type="xs:long" minOccurs="0" />
              <xs:element name="SpodNumber" msprop:Generator_ColumnVarNameInTable="columnSpodNumber" msprop:Generator_ColumnPropNameInRow="SpodNumber" msprop:Generator_ColumnPropNameInTable="SpodNumberColumn" msprop:Generator_UserColumnName="SpodNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SpodExpiryDate" msprop:Generator_ColumnVarNameInTable="columnSpodExpiryDate" msprop:Generator_ColumnPropNameInRow="SpodExpiryDate" msprop:Generator_ColumnPropNameInTable="SpodExpiryDateColumn" msprop:Generator_UserColumnName="SpodExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="J2ExpiryDate" msprop:Generator_ColumnVarNameInTable="columnJ2ExpiryDate" msprop:Generator_ColumnPropNameInRow="J2ExpiryDate" msprop:Generator_ColumnPropNameInTable="J2ExpiryDateColumn" msprop:Generator_UserColumnName="J2ExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Remark1" msprop:Generator_ColumnVarNameInTable="columnRemark1" msprop:Generator_ColumnPropNameInRow="Remark1" msprop:Generator_ColumnPropNameInTable="Remark1Column" msprop:Generator_UserColumnName="Remark1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark2" msprop:Generator_ColumnVarNameInTable="columnRemark2" msprop:Generator_ColumnPropNameInRow="Remark2" msprop:Generator_ColumnPropNameInTable="Remark2Column" msprop:Generator_UserColumnName="Remark2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark3" msprop:Generator_ColumnVarNameInTable="columnRemark3" msprop:Generator_ColumnPropNameInRow="Remark3" msprop:Generator_ColumnPropNameInTable="Remark3Column" msprop:Generator_UserColumnName="Remark3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark4" msprop:Generator_ColumnVarNameInTable="columnRemark4" msprop:Generator_ColumnPropNameInRow="Remark4" msprop:Generator_ColumnPropNameInTable="Remark4Column" msprop:Generator_UserColumnName="Remark4" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark5" msprop:Generator_ColumnVarNameInTable="columnRemark5" msprop:Generator_ColumnPropNameInRow="Remark5" msprop:Generator_ColumnPropNameInTable="Remark5Column" msprop:Generator_UserColumnName="Remark5" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark6" msprop:Generator_ColumnVarNameInTable="columnRemark6" msprop:Generator_ColumnPropNameInRow="Remark6" msprop:Generator_ColumnPropNameInTable="Remark6Column" msprop:Generator_UserColumnName="Remark6" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleMissionStatus" msprop:Generator_ColumnVarNameInTable="columnVehicleMissionStatus" msprop:Generator_ColumnPropNameInRow="VehicleMissionStatus" msprop:Generator_ColumnPropNameInTable="VehicleMissionStatusColumn" msprop:Generator_UserColumnName="VehicleMissionStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleQCStatus" msprop:Generator_ColumnVarNameInTable="columnVehicleQCStatus" msprop:Generator_ColumnPropNameInRow="VehicleQCStatus" msprop:Generator_ColumnPropNameInTable="VehicleQCStatusColumn" msprop:Generator_UserColumnName="VehicleQCStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InsertedUser" msprop:Generator_ColumnVarNameInTable="columnInsertedUser" msprop:Generator_ColumnPropNameInRow="InsertedUser" msprop:Generator_ColumnPropNameInTable="InsertedUserColumn" msprop:Generator_UserColumnName="InsertedUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InsertedDate" msprop:Generator_ColumnVarNameInTable="columnInsertedDate" msprop:Generator_ColumnPropNameInRow="InsertedDate" msprop:Generator_ColumnPropNameInTable="InsertedDateColumn" msprop:Generator_UserColumnName="InsertedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="UpdatedUser" msprop:Generator_ColumnVarNameInTable="columnUpdatedUser" msprop:Generator_ColumnPropNameInRow="UpdatedUser" msprop:Generator_ColumnPropNameInTable="UpdatedUserColumn" msprop:Generator_UserColumnName="UpdatedUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UpdatedDate" msprop:Generator_ColumnVarNameInTable="columnUpdatedDate" msprop:Generator_ColumnPropNameInRow="UpdatedDate" msprop:Generator_ColumnPropNameInTable="UpdatedDateColumn" msprop:Generator_UserColumnName="UpdatedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DataVersion" msprop:Generator_ColumnVarNameInTable="columnDataVersion" msprop:Generator_ColumnPropNameInRow="DataVersion" msprop:Generator_ColumnPropNameInTable="DataVersionColumn" msprop:Generator_UserColumnName="DataVersion" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MissionManifest" msprop:Generator_TableClassName="MissionManifestDataTable" msprop:Generator_TableVarName="tableMissionManifest" msprop:Generator_TablePropName="MissionManifest" msprop:Generator_RowDeletingName="MissionManifestRowDeleting" msprop:Generator_UserTableName="MissionManifest" msprop:Generator_RowChangingName="MissionManifestRowChanging" msprop:Generator_RowEvHandlerName="MissionManifestRowChangeEventHandler" msprop:Generator_RowDeletedName="MissionManifestRowDeleted" msprop:Generator_RowEvArgName="MissionManifestRowChangeEvent" msprop:Generator_RowChangedName="MissionManifestRowChanged" msprop:Generator_RowClassName="MissionManifestRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MissionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnMissionID" msprop:Generator_ColumnPropNameInRow="MissionID" msprop:Generator_ColumnPropNameInTable="MissionIDColumn" msprop:Generator_UserColumnName="MissionID" type="xs:long" />
              <xs:element name="TMR" msprop:Generator_ColumnVarNameInTable="columnTMR" msprop:Generator_ColumnPropNameInRow="TMR" msprop:Generator_ColumnPropNameInTable="TMRColumn" msprop:Generator_UserColumnName="TMR">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MissionDate" msprop:Generator_ColumnVarNameInTable="columnMissionDate" msprop:Generator_ColumnPropNameInRow="MissionDate" msprop:Generator_ColumnPropNameInTable="MissionDateColumn" msprop:Generator_UserColumnName="MissionDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MissionTypeCode" msprop:Generator_ColumnVarNameInTable="columnMissionTypeCode" msprop:Generator_ColumnPropNameInRow="MissionTypeCode" msprop:Generator_ColumnPropNameInTable="MissionTypeCodeColumn" msprop:Generator_UserColumnName="MissionTypeCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MissionNumber" msprop:Generator_ColumnVarNameInTable="columnMissionNumber" msprop:Generator_ColumnPropNameInRow="MissionNumber" msprop:Generator_ColumnPropNameInTable="MissionNumberColumn" msprop:Generator_UserColumnName="MissionNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MissionStatusCode" msprop:Generator_ColumnVarNameInTable="columnMissionStatusCode" msprop:Generator_ColumnPropNameInRow="MissionStatusCode" msprop:Generator_ColumnPropNameInTable="MissionStatusCodeColumn" msprop:Generator_UserColumnName="MissionStatusCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EscortingUnitCode" msprop:Generator_ColumnVarNameInTable="columnEscortingUnitCode" msprop:Generator_ColumnPropNameInRow="EscortingUnitCode" msprop:Generator_ColumnPropNameInTable="EscortingUnitCodeColumn" msprop:Generator_UserColumnName="EscortingUnitCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EscortingUnitPOC" msprop:Generator_ColumnVarNameInTable="columnEscortingUnitPOC" msprop:Generator_ColumnPropNameInRow="EscortingUnitPOC" msprop:Generator_ColumnPropNameInTable="EscortingUnitPOCColumn" msprop:Generator_UserColumnName="EscortingUnitPOC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EscortingUnitTEL" msprop:Generator_ColumnVarNameInTable="columnEscortingUnitTEL" msprop:Generator_ColumnPropNameInRow="EscortingUnitTEL" msprop:Generator_ColumnPropNameInTable="EscortingUnitTELColumn" msprop:Generator_UserColumnName="EscortingUnitTEL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RequestingUnitCode" msprop:Generator_ColumnVarNameInTable="columnRequestingUnitCode" msprop:Generator_ColumnPropNameInRow="RequestingUnitCode" msprop:Generator_ColumnPropNameInTable="RequestingUnitCodeColumn" msprop:Generator_UserColumnName="RequestingUnitCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RequestingUnitPOC" msprop:Generator_ColumnVarNameInTable="columnRequestingUnitPOC" msprop:Generator_ColumnPropNameInRow="RequestingUnitPOC" msprop:Generator_ColumnPropNameInTable="RequestingUnitPOCColumn" msprop:Generator_UserColumnName="RequestingUnitPOC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RequestingUnitTEL" msprop:Generator_ColumnVarNameInTable="columnRequestingUnitTEL" msprop:Generator_ColumnPropNameInRow="RequestingUnitTEL" msprop:Generator_ColumnPropNameInTable="RequestingUnitTELColumn" msprop:Generator_UserColumnName="RequestingUnitTEL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DaysOfRation" msprop:Generator_ColumnVarNameInTable="columnDaysOfRation" msprop:Generator_ColumnPropNameInRow="DaysOfRation" msprop:Generator_ColumnPropNameInTable="DaysOfRationColumn" msprop:Generator_UserColumnName="DaysOfRation" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PushDateTime" msprop:Generator_ColumnVarNameInTable="columnPushDateTime" msprop:Generator_ColumnPropNameInRow="PushDateTime" msprop:Generator_ColumnPropNameInTable="PushDateTimeColumn" msprop:Generator_UserColumnName="PushDateTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DepartureDateTime" msprop:Generator_ColumnVarNameInTable="columnDepartureDateTime" msprop:Generator_ColumnPropNameInRow="DepartureDateTime" msprop:Generator_ColumnPropNameInTable="DepartureDateTimeColumn" msprop:Generator_UserColumnName="DepartureDateTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RollOutDateTime" msprop:Generator_ColumnVarNameInTable="columnRollOutDateTime" msprop:Generator_ColumnPropNameInRow="RollOutDateTime" msprop:Generator_ColumnPropNameInTable="RollOutDateTimeColumn" msprop:Generator_UserColumnName="RollOutDateTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NoofFB" msprop:Generator_ColumnVarNameInTable="columnNoofFB" msprop:Generator_ColumnPropNameInRow="NoofFB" msprop:Generator_ColumnPropNameInTable="NoofFBColumn" msprop:Generator_UserColumnName="NoofFB" type="xs:int" minOccurs="0" />
              <xs:element name="NoofFBBT" msprop:Generator_ColumnVarNameInTable="columnNoofFBBT" msprop:Generator_ColumnPropNameInRow="NoofFBBT" msprop:Generator_ColumnPropNameInTable="NoofFBBTColumn" msprop:Generator_UserColumnName="NoofFBBT" type="xs:int" minOccurs="0" />
              <xs:element name="NoofHET" msprop:Generator_ColumnVarNameInTable="columnNoofHET" msprop:Generator_ColumnPropNameInRow="NoofHET" msprop:Generator_ColumnPropNameInTable="NoofHETColumn" msprop:Generator_UserColumnName="NoofHET" type="xs:int" minOccurs="0" />
              <xs:element name="NoofHETBT" msprop:Generator_ColumnVarNameInTable="columnNoofHETBT" msprop:Generator_ColumnPropNameInRow="NoofHETBT" msprop:Generator_ColumnPropNameInTable="NoofHETBTColumn" msprop:Generator_UserColumnName="NoofHETBT" type="xs:int" minOccurs="0" />
              <xs:element name="NoofDrivers" msprop:Generator_ColumnVarNameInTable="columnNoofDrivers" msprop:Generator_ColumnPropNameInRow="NoofDrivers" msprop:Generator_ColumnPropNameInTable="NoofDriversColumn" msprop:Generator_UserColumnName="NoofDrivers" type="xs:int" minOccurs="0" />
              <xs:element name="NoofACCs" msprop:Generator_ColumnVarNameInTable="columnNoofACCs" msprop:Generator_ColumnPropNameInRow="NoofACCs" msprop:Generator_ColumnPropNameInTable="NoofACCsColumn" msprop:Generator_UserColumnName="NoofACCs" type="xs:int" minOccurs="0" />
              <xs:element name="AccCivilID" msprop:Generator_ColumnVarNameInTable="columnAccCivilID" msprop:Generator_ColumnPropNameInRow="AccCivilID" msprop:Generator_ColumnPropNameInTable="AccCivilIDColumn" msprop:Generator_UserColumnName="AccCivilID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccName" msprop:Generator_ColumnVarNameInTable="columnAccName" msprop:Generator_ColumnPropNameInRow="AccName" msprop:Generator_ColumnPropNameInTable="AccNameColumn" msprop:Generator_UserColumnName="AccName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccTEL" msprop:Generator_ColumnVarNameInTable="columnAccTEL" msprop:Generator_ColumnPropNameInRow="AccTEL" msprop:Generator_ColumnPropNameInTable="AccTELColumn" msprop:Generator_UserColumnName="AccTEL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccVehicleNumber" msprop:Generator_ColumnVarNameInTable="columnAccVehicleNumber" msprop:Generator_ColumnPropNameInRow="AccVehicleNumber" msprop:Generator_ColumnPropNameInTable="AccVehicleNumberColumn" msprop:Generator_UserColumnName="AccVehicleNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MissionDetailID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnMissionDetailID" msprop:Generator_ColumnPropNameInRow="MissionDetailID" msprop:Generator_ColumnPropNameInTable="MissionDetailIDColumn" msprop:Generator_UserColumnName="MissionDetailID" type="xs:long" />
              <xs:element name="VehicleNumber" msprop:Generator_ColumnVarNameInTable="columnVehicleNumber" msprop:Generator_ColumnPropNameInRow="VehicleNumber" msprop:Generator_ColumnPropNameInTable="VehicleNumberColumn" msprop:Generator_UserColumnName="VehicleNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LicensePlateNumber" msprop:Generator_ColumnVarNameInTable="columnLicensePlateNumber" msprop:Generator_ColumnPropNameInRow="LicensePlateNumber" msprop:Generator_ColumnPropNameInTable="LicensePlateNumberColumn" msprop:Generator_UserColumnName="LicensePlateNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriverNumber" msprop:Generator_ColumnVarNameInTable="columnDriverNumber" msprop:Generator_ColumnPropNameInRow="DriverNumber" msprop:Generator_ColumnPropNameInTable="DriverNumberColumn" msprop:Generator_UserColumnName="DriverNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriverName" msprop:Generator_ColumnVarNameInTable="columnDriverName" msprop:Generator_ColumnPropNameInRow="DriverName" msprop:Generator_ColumnPropNameInTable="DriverNameColumn" msprop:Generator_UserColumnName="DriverName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nationality" msprop:Generator_ColumnVarNameInTable="columnNationality" msprop:Generator_ColumnPropNameInRow="Nationality" msprop:Generator_ColumnPropNameInTable="NationalityColumn" msprop:Generator_UserColumnName="Nationality" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PassportNumber" msprop:Generator_ColumnVarNameInTable="columnPassportNumber" msprop:Generator_ColumnPropNameInRow="PassportNumber" msprop:Generator_ColumnPropNameInTable="PassportNumberColumn" msprop:Generator_UserColumnName="PassportNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriverCivilID" msprop:Generator_ColumnVarNameInTable="columnDriverCivilID" msprop:Generator_ColumnPropNameInRow="DriverCivilID" msprop:Generator_ColumnPropNameInTable="DriverCivilIDColumn" msprop:Generator_UserColumnName="DriverCivilID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VisaNumber" msprop:Generator_ColumnVarNameInTable="columnVisaNumber" msprop:Generator_ColumnPropNameInRow="VisaNumber" msprop:Generator_ColumnPropNameInTable="VisaNumberColumn" msprop:Generator_UserColumnName="VisaNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VisaExpiryDate" msprop:Generator_ColumnVarNameInTable="columnVisaExpiryDate" msprop:Generator_ColumnPropNameInRow="VisaExpiryDate" msprop:Generator_ColumnPropNameInTable="VisaExpiryDateColumn" msprop:Generator_UserColumnName="VisaExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="LicenseExpiryDate" msprop:Generator_ColumnVarNameInTable="columnLicenseExpiryDate" msprop:Generator_ColumnPropNameInRow="LicenseExpiryDate" msprop:Generator_ColumnPropNameInTable="LicenseExpiryDateColumn" msprop:Generator_UserColumnName="LicenseExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrailerNumber" msprop:Generator_ColumnVarNameInTable="columnTrailerNumber" msprop:Generator_ColumnPropNameInRow="TrailerNumber" msprop:Generator_ColumnPropNameInTable="TrailerNumberColumn" msprop:Generator_UserColumnName="TrailerNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DepartureDate" msprop:Generator_ColumnVarNameInTable="columnDepartureDate" msprop:Generator_ColumnPropNameInRow="DepartureDate" msprop:Generator_ColumnPropNameInTable="DepartureDateColumn" msprop:Generator_UserColumnName="DepartureDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DepartureRemarks" msprop:Generator_ColumnVarNameInTable="columnDepartureRemarks" msprop:Generator_ColumnPropNameInRow="DepartureRemarks" msprop:Generator_ColumnPropNameInTable="DepartureRemarksColumn" msprop:Generator_UserColumnName="DepartureRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleOutboundMilage" msprop:Generator_ColumnVarNameInTable="columnVehicleOutboundMilage" msprop:Generator_ColumnPropNameInRow="VehicleOutboundMilage" msprop:Generator_ColumnPropNameInTable="VehicleOutboundMilageColumn" msprop:Generator_UserColumnName="VehicleOutboundMilage" type="xs:long" minOccurs="0" />
              <xs:element name="DriverReturnDate" msprop:Generator_ColumnVarNameInTable="columnDriverReturnDate" msprop:Generator_ColumnPropNameInRow="DriverReturnDate" msprop:Generator_ColumnPropNameInTable="DriverReturnDateColumn" msprop:Generator_UserColumnName="DriverReturnDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DriverReturnRemarks" msprop:Generator_ColumnVarNameInTable="columnDriverReturnRemarks" msprop:Generator_ColumnPropNameInRow="DriverReturnRemarks" msprop:Generator_ColumnPropNameInTable="DriverReturnRemarksColumn" msprop:Generator_UserColumnName="DriverReturnRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccomodationDate" msprop:Generator_ColumnVarNameInTable="columnAccomodationDate" msprop:Generator_ColumnPropNameInRow="AccomodationDate" msprop:Generator_ColumnPropNameInTable="AccomodationDateColumn" msprop:Generator_UserColumnName="AccomodationDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AccomodationRemarks" msprop:Generator_ColumnVarNameInTable="columnAccomodationRemarks" msprop:Generator_ColumnPropNameInRow="AccomodationRemarks" msprop:Generator_ColumnPropNameInTable="AccomodationRemarksColumn" msprop:Generator_UserColumnName="AccomodationRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleReturnDate" msprop:Generator_ColumnVarNameInTable="columnVehicleReturnDate" msprop:Generator_ColumnPropNameInRow="VehicleReturnDate" msprop:Generator_ColumnPropNameInTable="VehicleReturnDateColumn" msprop:Generator_UserColumnName="VehicleReturnDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VehicleReturnRemarks" msprop:Generator_ColumnVarNameInTable="columnVehicleReturnRemarks" msprop:Generator_ColumnPropNameInRow="VehicleReturnRemarks" msprop:Generator_ColumnPropNameInTable="VehicleReturnRemarksColumn" msprop:Generator_UserColumnName="VehicleReturnRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleInboundMilage" msprop:Generator_ColumnVarNameInTable="columnVehicleInboundMilage" msprop:Generator_ColumnPropNameInRow="VehicleInboundMilage" msprop:Generator_ColumnPropNameInTable="VehicleInboundMilageColumn" msprop:Generator_UserColumnName="VehicleInboundMilage" type="xs:long" minOccurs="0" />
              <xs:element name="VehicleQCPassDate" msprop:Generator_ColumnVarNameInTable="columnVehicleQCPassDate" msprop:Generator_ColumnPropNameInRow="VehicleQCPassDate" msprop:Generator_ColumnPropNameInTable="VehicleQCPassDateColumn" msprop:Generator_UserColumnName="VehicleQCPassDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VehicleQCPassRemarks" msprop:Generator_ColumnVarNameInTable="columnVehicleQCPassRemarks" msprop:Generator_ColumnPropNameInRow="VehicleQCPassRemarks" msprop:Generator_ColumnPropNameInTable="VehicleQCPassRemarksColumn" msprop:Generator_UserColumnName="VehicleQCPassRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleQCRejectedDate" msprop:Generator_ColumnVarNameInTable="columnVehicleQCRejectedDate" msprop:Generator_ColumnPropNameInRow="VehicleQCRejectedDate" msprop:Generator_ColumnPropNameInTable="VehicleQCRejectedDateColumn" msprop:Generator_UserColumnName="VehicleQCRejectedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VehicleQCRejectedRemarks" msprop:Generator_ColumnVarNameInTable="columnVehicleQCRejectedRemarks" msprop:Generator_ColumnPropNameInRow="VehicleQCRejectedRemarks" msprop:Generator_ColumnPropNameInTable="VehicleQCRejectedRemarksColumn" msprop:Generator_UserColumnName="VehicleQCRejectedRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DriversAvailabilityStatusReport" msprop:Generator_TableClassName="DriversAvailabilityStatusReportDataTable" msprop:Generator_TableVarName="tableDriversAvailabilityStatusReport" msprop:Generator_TablePropName="DriversAvailabilityStatusReport" msprop:Generator_RowDeletingName="DriversAvailabilityStatusReportRowDeleting" msprop:Generator_UserTableName="DriversAvailabilityStatusReport" msprop:Generator_RowChangingName="DriversAvailabilityStatusReportRowChanging" msprop:Generator_RowEvHandlerName="DriversAvailabilityStatusReportRowChangeEventHandler" msprop:Generator_RowDeletedName="DriversAvailabilityStatusReportRowDeleted" msprop:Generator_RowEvArgName="DriversAvailabilityStatusReportRowChangeEvent" msprop:Generator_RowChangedName="DriversAvailabilityStatusReportRowChanged" msprop:Generator_RowClassName="DriversAvailabilityStatusReportRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Availability" msprop:Generator_ColumnVarNameInTable="columnAvailability" msprop:Generator_ColumnPropNameInRow="Availability" msprop:Generator_ColumnPropNameInTable="AvailabilityColumn" msprop:Generator_UserColumnName="Availability" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Accomodation" msprop:Generator_ColumnVarNameInTable="columnAccomodation" msprop:Generator_ColumnPropNameInRow="Accomodation" msprop:Generator_ColumnPropNameInTable="AccomodationColumn" msprop:Generator_UserColumnName="Accomodation" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RestHours" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnRestHours" msprop:Generator_ColumnPropNameInRow="RestHours" msprop:Generator_ColumnPropNameInTable="RestHoursColumn" msprop:Generator_UserColumnName="RestHours" type="xs:int" minOccurs="0" />
              <xs:element name="EmployeeNo" msprop:Generator_ColumnVarNameInTable="columnEmployeeNo" msprop:Generator_ColumnPropNameInRow="EmployeeNo" msprop:Generator_ColumnPropNameInTable="EmployeeNoColumn" msprop:Generator_UserColumnName="EmployeeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriverName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDriverName" msprop:Generator_ColumnPropNameInRow="DriverName" msprop:Generator_ColumnPropNameInTable="DriverNameColumn" msprop:Generator_UserColumnName="DriverName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="301" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DesignationCode" msprop:Generator_ColumnVarNameInTable="columnDesignationCode" msprop:Generator_ColumnPropNameInRow="DesignationCode" msprop:Generator_ColumnPropNameInTable="DesignationCodeColumn" msprop:Generator_UserColumnName="DesignationCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShuaibaPassExpiryDate" msprop:Generator_ColumnVarNameInTable="columnShuaibaPassExpiryDate" msprop:Generator_ColumnPropNameInRow="ShuaibaPassExpiryDate" msprop:Generator_ColumnPropNameInTable="ShuaibaPassExpiryDateColumn" msprop:Generator_UserColumnName="ShuaibaPassExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="J2SouthPassExpiry" msprop:Generator_ColumnVarNameInTable="columnJ2SouthPassExpiry" msprop:Generator_ColumnPropNameInRow="J2SouthPassExpiry" msprop:Generator_ColumnPropNameInTable="J2SouthPassExpiryColumn" msprop:Generator_UserColumnName="J2SouthPassExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="J2NorthPassExpiry" msprop:Generator_ColumnVarNameInTable="columnJ2NorthPassExpiry" msprop:Generator_ColumnPropNameInRow="J2NorthPassExpiry" msprop:Generator_ColumnPropNameInTable="J2NorthPassExpiryColumn" msprop:Generator_UserColumnName="J2NorthPassExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Nationality" msprop:Generator_ColumnVarNameInTable="columnNationality" msprop:Generator_ColumnPropNameInRow="Nationality" msprop:Generator_ColumnPropNameInTable="NationalityColumn" msprop:Generator_UserColumnName="Nationality" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CivilID" msprop:Generator_ColumnVarNameInTable="columnCivilID" msprop:Generator_ColumnPropNameInRow="CivilID" msprop:Generator_ColumnPropNameInTable="CivilIDColumn" msprop:Generator_UserColumnName="CivilID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PassportNo" msprop:Generator_ColumnVarNameInTable="columnPassportNo" msprop:Generator_ColumnPropNameInRow="PassportNo" msprop:Generator_ColumnPropNameInTable="PassportNoColumn" msprop:Generator_UserColumnName="PassportNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ResidencyNo" msprop:Generator_ColumnVarNameInTable="columnResidencyNo" msprop:Generator_ColumnPropNameInRow="ResidencyNo" msprop:Generator_ColumnPropNameInTable="ResidencyNoColumn" msprop:Generator_UserColumnName="ResidencyNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CivilIDExpairyDate" msprop:Generator_ColumnVarNameInTable="columnCivilIDExpairyDate" msprop:Generator_ColumnPropNameInRow="CivilIDExpairyDate" msprop:Generator_ColumnPropNameInTable="CivilIDExpairyDateColumn" msprop:Generator_UserColumnName="CivilIDExpairyDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PassportDateOfExpiry" msprop:Generator_ColumnVarNameInTable="columnPassportDateOfExpiry" msprop:Generator_ColumnPropNameInRow="PassportDateOfExpiry" msprop:Generator_ColumnPropNameInTable="PassportDateOfExpiryColumn" msprop:Generator_UserColumnName="PassportDateOfExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DrivingLicenceExpiryDate" msprop:Generator_ColumnVarNameInTable="columnDrivingLicenceExpiryDate" msprop:Generator_ColumnPropNameInRow="DrivingLicenceExpiryDate" msprop:Generator_ColumnPropNameInTable="DrivingLicenceExpiryDateColumn" msprop:Generator_UserColumnName="DrivingLicenceExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="USFVirginiaBadgeNo" msprop:Generator_ColumnVarNameInTable="columnUSFVirginiaBadgeNo" msprop:Generator_ColumnPropNameInRow="USFVirginiaBadgeNo" msprop:Generator_ColumnPropNameInTable="USFVirginiaBadgeNoColumn" msprop:Generator_UserColumnName="USFVirginiaBadgeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="USFVirginiaBadgeExpiry" msprop:Generator_ColumnVarNameInTable="columnUSFVirginiaBadgeExpiry" msprop:Generator_ColumnPropNameInRow="USFVirginiaBadgeExpiry" msprop:Generator_ColumnPropNameInTable="USFVirginiaBadgeExpiryColumn" msprop:Generator_UserColumnName="USFVirginiaBadgeExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ASGKUBadgeNo" msprop:Generator_ColumnVarNameInTable="columnASGKUBadgeNo" msprop:Generator_ColumnPropNameInRow="ASGKUBadgeNo" msprop:Generator_ColumnPropNameInTable="ASGKUBadgeNoColumn" msprop:Generator_UserColumnName="ASGKUBadgeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ASGKUBadgeExpiry" msprop:Generator_ColumnVarNameInTable="columnASGKUBadgeExpiry" msprop:Generator_ColumnPropNameInRow="ASGKUBadgeExpiry" msprop:Generator_ColumnPropNameInTable="ASGKUBadgeExpiryColumn" msprop:Generator_UserColumnName="ASGKUBadgeExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ShuaibaPassNo" msprop:Generator_ColumnVarNameInTable="columnShuaibaPassNo" msprop:Generator_ColumnPropNameInRow="ShuaibaPassNo" msprop:Generator_ColumnPropNameInTable="ShuaibaPassNoColumn" msprop:Generator_UserColumnName="ShuaibaPassNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrainingRemark" msprop:Generator_ColumnVarNameInTable="columnTrainingRemark" msprop:Generator_ColumnPropNameInRow="TrainingRemark" msprop:Generator_ColumnPropNameInTable="TrainingRemarkColumn" msprop:Generator_UserColumnName="TrainingRemark" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ViolationRemark" msprop:Generator_ColumnVarNameInTable="columnViolationRemark" msprop:Generator_ColumnPropNameInRow="ViolationRemark" msprop:Generator_ColumnPropNameInTable="ViolationRemarkColumn" msprop:Generator_UserColumnName="ViolationRemark" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark1" msprop:Generator_ColumnVarNameInTable="columnRemark1" msprop:Generator_ColumnPropNameInRow="Remark1" msprop:Generator_ColumnPropNameInTable="Remark1Column" msprop:Generator_UserColumnName="Remark1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastTMR" msprop:Generator_ColumnVarNameInTable="columnLastTMR" msprop:Generator_ColumnPropNameInRow="LastTMR" msprop:Generator_ColumnPropNameInTable="LastTMRColumn" msprop:Generator_UserColumnName="LastTMR">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriverCivilID" msprop:Generator_ColumnVarNameInTable="columnDriverCivilID" msprop:Generator_ColumnPropNameInRow="DriverCivilID" msprop:Generator_ColumnPropNameInTable="DriverCivilIDColumn" msprop:Generator_UserColumnName="DriverCivilID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CumulativeWorkedHours" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCumulativeWorkedHours" msprop:Generator_ColumnPropNameInRow="CumulativeWorkedHours" msprop:Generator_ColumnPropNameInTable="CumulativeWorkedHoursColumn" msprop:Generator_UserColumnName="CumulativeWorkedHours" type="xs:decimal" minOccurs="0" />
              <xs:element name="LastRetunDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnLastRetunDate" msprop:Generator_ColumnPropNameInRow="LastRetunDate" msprop:Generator_ColumnPropNameInTable="LastRetunDateColumn" msprop:Generator_UserColumnName="LastRetunDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MissionType" msprop:Generator_ColumnVarNameInTable="columnMissionType" msprop:Generator_ColumnPropNameInRow="MissionType" msprop:Generator_ColumnPropNameInTable="MissionTypeColumn" msprop:Generator_UserColumnName="MissionType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MissionRollupReport" msprop:Generator_TableClassName="MissionRollupReportDataTable" msprop:Generator_TableVarName="tableMissionRollupReport" msprop:Generator_TablePropName="MissionRollupReport" msprop:Generator_RowDeletingName="MissionRollupReportRowDeleting" msprop:Generator_UserTableName="MissionRollupReport" msprop:Generator_RowChangingName="MissionRollupReportRowChanging" msprop:Generator_RowEvHandlerName="MissionRollupReportRowChangeEventHandler" msprop:Generator_RowDeletedName="MissionRollupReportRowDeleted" msprop:Generator_RowEvArgName="MissionRollupReportRowChangeEvent" msprop:Generator_RowChangedName="MissionRollupReportRowChanged" msprop:Generator_RowClassName="MissionRollupReportRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MissionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnMissionID" msprop:Generator_ColumnPropNameInRow="MissionID" msprop:Generator_ColumnPropNameInTable="MissionIDColumn" msprop:Generator_UserColumnName="MissionID" type="xs:long" />
              <xs:element name="MissionNumber" msprop:Generator_ColumnVarNameInTable="columnMissionNumber" msprop:Generator_ColumnPropNameInRow="MissionNumber" msprop:Generator_ColumnPropNameInTable="MissionNumberColumn" msprop:Generator_UserColumnName="MissionNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TMR" msprop:Generator_ColumnVarNameInTable="columnTMR" msprop:Generator_ColumnPropNameInRow="TMR" msprop:Generator_ColumnPropNameInTable="TMRColumn" msprop:Generator_UserColumnName="TMR">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NoofHET" msprop:Generator_ColumnVarNameInTable="columnNoofHET" msprop:Generator_ColumnPropNameInRow="NoofHET" msprop:Generator_ColumnPropNameInTable="NoofHETColumn" msprop:Generator_UserColumnName="NoofHET" type="xs:int" minOccurs="0" />
              <xs:element name="NoofHETBT" msprop:Generator_ColumnVarNameInTable="columnNoofHETBT" msprop:Generator_ColumnPropNameInRow="NoofHETBT" msprop:Generator_ColumnPropNameInTable="NoofHETBTColumn" msprop:Generator_UserColumnName="NoofHETBT" type="xs:int" minOccurs="0" />
              <xs:element name="NoofFB" msprop:Generator_ColumnVarNameInTable="columnNoofFB" msprop:Generator_ColumnPropNameInRow="NoofFB" msprop:Generator_ColumnPropNameInTable="NoofFBColumn" msprop:Generator_UserColumnName="NoofFB" type="xs:int" minOccurs="0" />
              <xs:element name="NoofFBBT" msprop:Generator_ColumnVarNameInTable="columnNoofFBBT" msprop:Generator_ColumnPropNameInRow="NoofFBBT" msprop:Generator_ColumnPropNameInTable="NoofFBBTColumn" msprop:Generator_UserColumnName="NoofFBBT" type="xs:int" minOccurs="0" />
              <xs:element name="MissionDate" msprop:Generator_ColumnVarNameInTable="columnMissionDate" msprop:Generator_ColumnPropNameInRow="MissionDate" msprop:Generator_ColumnPropNameInTable="MissionDateColumn" msprop:Generator_UserColumnName="MissionDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RollOutDateTime" msprop:Generator_ColumnVarNameInTable="columnRollOutDateTime" msprop:Generator_ColumnPropNameInRow="RollOutDateTime" msprop:Generator_ColumnPropNameInTable="RollOutDateTimeColumn" msprop:Generator_UserColumnName="RollOutDateTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Origin" msprop:Generator_ColumnVarNameInTable="columnOrigin" msprop:Generator_ColumnPropNameInRow="Origin" msprop:Generator_ColumnPropNameInTable="OriginColumn" msprop:Generator_UserColumnName="Origin" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Destination" msprop:Generator_ColumnVarNameInTable="columnDestination" msprop:Generator_ColumnPropNameInRow="Destination" msprop:Generator_ColumnPropNameInTable="DestinationColumn" msprop:Generator_UserColumnName="Destination" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remarks" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CompanyCode" msprop:Generator_ColumnVarNameInTable="columnCompanyCode" msprop:Generator_ColumnPropNameInRow="CompanyCode" msprop:Generator_ColumnPropNameInTable="CompanyCodeColumn" msprop:Generator_UserColumnName="CompanyCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MissionTypeDescription" msprop:Generator_ColumnVarNameInTable="columnMissionTypeDescription" msprop:Generator_ColumnPropNameInRow="MissionTypeDescription" msprop:Generator_ColumnPropNameInTable="MissionTypeDescriptionColumn" msprop:Generator_UserColumnName="MissionTypeDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MissionDetailsReport" msprop:Generator_TableClassName="MissionDetailsReportDataTable" msprop:Generator_TableVarName="tableMissionDetailsReport" msprop:Generator_TablePropName="MissionDetailsReport" msprop:Generator_RowDeletingName="MissionDetailsReportRowDeleting" msprop:Generator_UserTableName="MissionDetailsReport" msprop:Generator_RowChangingName="MissionDetailsReportRowChanging" msprop:Generator_RowEvHandlerName="MissionDetailsReportRowChangeEventHandler" msprop:Generator_RowDeletedName="MissionDetailsReportRowDeleted" msprop:Generator_RowEvArgName="MissionDetailsReportRowChangeEvent" msprop:Generator_RowChangedName="MissionDetailsReportRowChanged" msprop:Generator_RowClassName="MissionDetailsReportRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MissionDetailID" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMissionDetailID" msprop:Generator_ColumnPropNameInRow="MissionDetailID" msprop:Generator_ColumnPropNameInTable="MissionDetailIDColumn" msprop:Generator_UserColumnName="MissionDetailID" type="xs:long" minOccurs="0" />
              <xs:element name="MissionID" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMissionID" msprop:Generator_ColumnPropNameInRow="MissionID" msprop:Generator_ColumnPropNameInTable="MissionIDColumn" msprop:Generator_UserColumnName="MissionID" type="xs:long" minOccurs="0" />
              <xs:element name="VehicleNumber" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVehicleNumber" msprop:Generator_ColumnPropNameInRow="VehicleNumber" msprop:Generator_ColumnPropNameInTable="VehicleNumberColumn" msprop:Generator_UserColumnName="VehicleNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LicensePlateNumber" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnLicensePlateNumber" msprop:Generator_ColumnPropNameInRow="LicensePlateNumber" msprop:Generator_ColumnPropNameInTable="LicensePlateNumberColumn" msprop:Generator_UserColumnName="LicensePlateNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriverNumber" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDriverNumber" msprop:Generator_ColumnPropNameInRow="DriverNumber" msprop:Generator_ColumnPropNameInTable="DriverNumberColumn" msprop:Generator_UserColumnName="DriverNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriverName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDriverName" msprop:Generator_ColumnPropNameInRow="DriverName" msprop:Generator_ColumnPropNameInTable="DriverNameColumn" msprop:Generator_UserColumnName="DriverName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nationality" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNationality" msprop:Generator_ColumnPropNameInRow="Nationality" msprop:Generator_ColumnPropNameInTable="NationalityColumn" msprop:Generator_UserColumnName="Nationality" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PassportNumber" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPassportNumber" msprop:Generator_ColumnPropNameInRow="PassportNumber" msprop:Generator_ColumnPropNameInTable="PassportNumberColumn" msprop:Generator_UserColumnName="PassportNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriverCivilID" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDriverCivilID" msprop:Generator_ColumnPropNameInRow="DriverCivilID" msprop:Generator_ColumnPropNameInTable="DriverCivilIDColumn" msprop:Generator_UserColumnName="DriverCivilID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VisaNumber" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVisaNumber" msprop:Generator_ColumnPropNameInRow="VisaNumber" msprop:Generator_ColumnPropNameInTable="VisaNumberColumn" msprop:Generator_UserColumnName="VisaNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VisaExpiryDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVisaExpiryDate" msprop:Generator_ColumnPropNameInRow="VisaExpiryDate" msprop:Generator_ColumnPropNameInTable="VisaExpiryDateColumn" msprop:Generator_UserColumnName="VisaExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="LicenseExpiryDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnLicenseExpiryDate" msprop:Generator_ColumnPropNameInRow="LicenseExpiryDate" msprop:Generator_ColumnPropNameInTable="LicenseExpiryDateColumn" msprop:Generator_UserColumnName="LicenseExpiryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Model" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrailerNumber" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTrailerNumber" msprop:Generator_ColumnPropNameInRow="TrailerNumber" msprop:Generator_ColumnPropNameInTable="TrailerNumberColumn" msprop:Generator_UserColumnName="TrailerNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DepartureDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDepartureDate" msprop:Generator_ColumnPropNameInRow="DepartureDate" msprop:Generator_ColumnPropNameInTable="DepartureDateColumn" msprop:Generator_UserColumnName="DepartureDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DepartureRemarks" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDepartureRemarks" msprop:Generator_ColumnPropNameInRow="DepartureRemarks" msprop:Generator_ColumnPropNameInTable="DepartureRemarksColumn" msprop:Generator_UserColumnName="DepartureRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleOutboundMilage" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVehicleOutboundMilage" msprop:Generator_ColumnPropNameInRow="VehicleOutboundMilage" msprop:Generator_ColumnPropNameInTable="VehicleOutboundMilageColumn" msprop:Generator_UserColumnName="VehicleOutboundMilage" type="xs:long" minOccurs="0" />
              <xs:element name="DriverReturnDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDriverReturnDate" msprop:Generator_ColumnPropNameInRow="DriverReturnDate" msprop:Generator_ColumnPropNameInTable="DriverReturnDateColumn" msprop:Generator_UserColumnName="DriverReturnDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DriverReturnRemarks" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDriverReturnRemarks" msprop:Generator_ColumnPropNameInRow="DriverReturnRemarks" msprop:Generator_ColumnPropNameInTable="DriverReturnRemarksColumn" msprop:Generator_UserColumnName="DriverReturnRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccomodationDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAccomodationDate" msprop:Generator_ColumnPropNameInRow="AccomodationDate" msprop:Generator_ColumnPropNameInTable="AccomodationDateColumn" msprop:Generator_UserColumnName="AccomodationDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AccomodationRemarks" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAccomodationRemarks" msprop:Generator_ColumnPropNameInRow="AccomodationRemarks" msprop:Generator_ColumnPropNameInTable="AccomodationRemarksColumn" msprop:Generator_UserColumnName="AccomodationRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleReturnDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVehicleReturnDate" msprop:Generator_ColumnPropNameInRow="VehicleReturnDate" msprop:Generator_ColumnPropNameInTable="VehicleReturnDateColumn" msprop:Generator_UserColumnName="VehicleReturnDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VehicleReturnRemarks" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVehicleReturnRemarks" msprop:Generator_ColumnPropNameInRow="VehicleReturnRemarks" msprop:Generator_ColumnPropNameInTable="VehicleReturnRemarksColumn" msprop:Generator_UserColumnName="VehicleReturnRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleInboundMilage" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVehicleInboundMilage" msprop:Generator_ColumnPropNameInRow="VehicleInboundMilage" msprop:Generator_ColumnPropNameInTable="VehicleInboundMilageColumn" msprop:Generator_UserColumnName="VehicleInboundMilage" type="xs:long" minOccurs="0" />
              <xs:element name="VehicleQCPassDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVehicleQCPassDate" msprop:Generator_ColumnPropNameInRow="VehicleQCPassDate" msprop:Generator_ColumnPropNameInTable="VehicleQCPassDateColumn" msprop:Generator_UserColumnName="VehicleQCPassDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VehicleQCPassRemarks" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVehicleQCPassRemarks" msprop:Generator_ColumnPropNameInRow="VehicleQCPassRemarks" msprop:Generator_ColumnPropNameInTable="VehicleQCPassRemarksColumn" msprop:Generator_UserColumnName="VehicleQCPassRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleQCRejectedDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVehicleQCRejectedDate" msprop:Generator_ColumnPropNameInRow="VehicleQCRejectedDate" msprop:Generator_ColumnPropNameInTable="VehicleQCRejectedDateColumn" msprop:Generator_UserColumnName="VehicleQCRejectedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VehicleQCRejectedRemarks" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVehicleQCRejectedRemarks" msprop:Generator_ColumnPropNameInRow="VehicleQCRejectedRemarks" msprop:Generator_ColumnPropNameInTable="VehicleQCRejectedRemarksColumn" msprop:Generator_UserColumnName="VehicleQCRejectedRemarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InsertedUser" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnInsertedUser" msprop:Generator_ColumnPropNameInRow="InsertedUser" msprop:Generator_ColumnPropNameInTable="InsertedUserColumn" msprop:Generator_UserColumnName="InsertedUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InsertedDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnInsertedDate" msprop:Generator_ColumnPropNameInRow="InsertedDate" msprop:Generator_ColumnPropNameInTable="InsertedDateColumn" msprop:Generator_UserColumnName="InsertedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="UpdatedUser" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnUpdatedUser" msprop:Generator_ColumnPropNameInRow="UpdatedUser" msprop:Generator_ColumnPropNameInTable="UpdatedUserColumn" msprop:Generator_UserColumnName="UpdatedUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UpdatedDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnUpdatedDate" msprop:Generator_ColumnPropNameInRow="UpdatedDate" msprop:Generator_ColumnPropNameInTable="UpdatedDateColumn" msprop:Generator_UserColumnName="UpdatedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DataVersion" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDataVersion" msprop:Generator_ColumnPropNameInRow="DataVersion" msprop:Generator_ColumnPropNameInTable="DataVersionColumn" msprop:Generator_UserColumnName="DataVersion" type="xs:long" minOccurs="0" />
              <xs:element name="MissionID1" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMissionID1" msprop:Generator_ColumnPropNameInRow="MissionID1" msprop:Generator_ColumnPropNameInTable="MissionID1Column" msprop:Generator_UserColumnName="MissionID1" type="xs:long" minOccurs="0" />
              <xs:element name="TMR" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTMR" msprop:Generator_ColumnPropNameInRow="TMR" msprop:Generator_ColumnPropNameInTable="TMRColumn" msprop:Generator_UserColumnName="TMR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MissionDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMissionDate" msprop:Generator_ColumnPropNameInRow="MissionDate" msprop:Generator_ColumnPropNameInTable="MissionDateColumn" msprop:Generator_UserColumnName="MissionDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MissionTypeCode" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMissionTypeCode" msprop:Generator_ColumnPropNameInRow="MissionTypeCode" msprop:Generator_ColumnPropNameInTable="MissionTypeCodeColumn" msprop:Generator_UserColumnName="MissionTypeCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MissionNumber" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMissionNumber" msprop:Generator_ColumnPropNameInRow="MissionNumber" msprop:Generator_ColumnPropNameInTable="MissionNumberColumn" msprop:Generator_UserColumnName="MissionNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MissionStatusCode" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMissionStatusCode" msprop:Generator_ColumnPropNameInRow="MissionStatusCode" msprop:Generator_ColumnPropNameInTable="MissionStatusCodeColumn" msprop:Generator_UserColumnName="MissionStatusCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EscortingUnitCode" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnEscortingUnitCode" msprop:Generator_ColumnPropNameInRow="EscortingUnitCode" msprop:Generator_ColumnPropNameInTable="EscortingUnitCodeColumn" msprop:Generator_UserColumnName="EscortingUnitCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EscortingUnitPOC" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnEscortingUnitPOC" msprop:Generator_ColumnPropNameInRow="EscortingUnitPOC" msprop:Generator_ColumnPropNameInTable="EscortingUnitPOCColumn" msprop:Generator_UserColumnName="EscortingUnitPOC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EscortingUnitTEL" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnEscortingUnitTEL" msprop:Generator_ColumnPropNameInRow="EscortingUnitTEL" msprop:Generator_ColumnPropNameInTable="EscortingUnitTELColumn" msprop:Generator_UserColumnName="EscortingUnitTEL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RequestingUnitCode" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnRequestingUnitCode" msprop:Generator_ColumnPropNameInRow="RequestingUnitCode" msprop:Generator_ColumnPropNameInTable="RequestingUnitCodeColumn" msprop:Generator_UserColumnName="RequestingUnitCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RequestingUnitPOC" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnRequestingUnitPOC" msprop:Generator_ColumnPropNameInRow="RequestingUnitPOC" msprop:Generator_ColumnPropNameInTable="RequestingUnitPOCColumn" msprop:Generator_UserColumnName="RequestingUnitPOC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RequestingUnitTEL" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnRequestingUnitTEL" msprop:Generator_ColumnPropNameInRow="RequestingUnitTEL" msprop:Generator_ColumnPropNameInTable="RequestingUnitTELColumn" msprop:Generator_UserColumnName="RequestingUnitTEL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DaysOfRation" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDaysOfRation" msprop:Generator_ColumnPropNameInRow="DaysOfRation" msprop:Generator_ColumnPropNameInTable="DaysOfRationColumn" msprop:Generator_UserColumnName="DaysOfRation" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PushDateTime" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPushDateTime" msprop:Generator_ColumnPropNameInRow="PushDateTime" msprop:Generator_ColumnPropNameInTable="PushDateTimeColumn" msprop:Generator_UserColumnName="PushDateTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DepartureDateTime" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDepartureDateTime" msprop:Generator_ColumnPropNameInRow="DepartureDateTime" msprop:Generator_ColumnPropNameInTable="DepartureDateTimeColumn" msprop:Generator_UserColumnName="DepartureDateTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RollOutDateTime" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnRollOutDateTime" msprop:Generator_ColumnPropNameInRow="RollOutDateTime" msprop:Generator_ColumnPropNameInTable="RollOutDateTimeColumn" msprop:Generator_UserColumnName="RollOutDateTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NoofFB" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNoofFB" msprop:Generator_ColumnPropNameInRow="NoofFB" msprop:Generator_ColumnPropNameInTable="NoofFBColumn" msprop:Generator_UserColumnName="NoofFB" type="xs:int" minOccurs="0" />
              <xs:element name="NoofFBBT" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNoofFBBT" msprop:Generator_ColumnPropNameInRow="NoofFBBT" msprop:Generator_ColumnPropNameInTable="NoofFBBTColumn" msprop:Generator_UserColumnName="NoofFBBT" type="xs:int" minOccurs="0" />
              <xs:element name="NoofHET" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNoofHET" msprop:Generator_ColumnPropNameInRow="NoofHET" msprop:Generator_ColumnPropNameInTable="NoofHETColumn" msprop:Generator_UserColumnName="NoofHET" type="xs:int" minOccurs="0" />
              <xs:element name="NoofHETBT" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNoofHETBT" msprop:Generator_ColumnPropNameInRow="NoofHETBT" msprop:Generator_ColumnPropNameInTable="NoofHETBTColumn" msprop:Generator_UserColumnName="NoofHETBT" type="xs:int" minOccurs="0" />
              <xs:element name="NoofDrivers" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNoofDrivers" msprop:Generator_ColumnPropNameInRow="NoofDrivers" msprop:Generator_ColumnPropNameInTable="NoofDriversColumn" msprop:Generator_UserColumnName="NoofDrivers" type="xs:int" minOccurs="0" />
              <xs:element name="NoofACCs" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNoofACCs" msprop:Generator_ColumnPropNameInRow="NoofACCs" msprop:Generator_ColumnPropNameInTable="NoofACCsColumn" msprop:Generator_UserColumnName="NoofACCs" type="xs:int" minOccurs="0" />
              <xs:element name="CompanyCode" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCompanyCode" msprop:Generator_ColumnPropNameInRow="CompanyCode" msprop:Generator_ColumnPropNameInTable="CompanyCodeColumn" msprop:Generator_UserColumnName="CompanyCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccCivilID" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAccCivilID" msprop:Generator_ColumnPropNameInRow="AccCivilID" msprop:Generator_ColumnPropNameInTable="AccCivilIDColumn" msprop:Generator_UserColumnName="AccCivilID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAccName" msprop:Generator_ColumnPropNameInRow="AccName" msprop:Generator_ColumnPropNameInTable="AccNameColumn" msprop:Generator_UserColumnName="AccName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccTEL" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAccTEL" msprop:Generator_ColumnPropNameInRow="AccTEL" msprop:Generator_ColumnPropNameInTable="AccTELColumn" msprop:Generator_UserColumnName="AccTEL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccVehicleNumber" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAccVehicleNumber" msprop:Generator_ColumnPropNameInRow="AccVehicleNumber" msprop:Generator_ColumnPropNameInTable="AccVehicleNumberColumn" msprop:Generator_UserColumnName="AccVehicleNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Origin" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnOrigin" msprop:Generator_ColumnPropNameInRow="Origin" msprop:Generator_ColumnPropNameInTable="OriginColumn" msprop:Generator_UserColumnName="Origin" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Destination" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDestination" msprop:Generator_ColumnPropNameInRow="Destination" msprop:Generator_ColumnPropNameInTable="DestinationColumn" msprop:Generator_UserColumnName="Destination" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remarks" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InsertedUser1" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnInsertedUser1" msprop:Generator_ColumnPropNameInRow="InsertedUser1" msprop:Generator_ColumnPropNameInTable="InsertedUser1Column" msprop:Generator_UserColumnName="InsertedUser1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InsertedDate1" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnInsertedDate1" msprop:Generator_ColumnPropNameInRow="InsertedDate1" msprop:Generator_ColumnPropNameInTable="InsertedDate1Column" msprop:Generator_UserColumnName="InsertedDate1" type="xs:dateTime" minOccurs="0" />
              <xs:element name="UpdatedUser1" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnUpdatedUser1" msprop:Generator_ColumnPropNameInRow="UpdatedUser1" msprop:Generator_ColumnPropNameInTable="UpdatedUser1Column" msprop:Generator_UserColumnName="UpdatedUser1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UpdatedDate1" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnUpdatedDate1" msprop:Generator_ColumnPropNameInRow="UpdatedDate1" msprop:Generator_ColumnPropNameInTable="UpdatedDate1Column" msprop:Generator_UserColumnName="UpdatedDate1" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DataVersion1" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDataVersion1" msprop:Generator_ColumnPropNameInRow="DataVersion1" msprop:Generator_ColumnPropNameInTable="DataVersion1Column" msprop:Generator_UserColumnName="DataVersion1" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="AvailabilityReport" msprop:Generator_TableClassName="AvailabilityReportDataTable" msprop:Generator_TableVarName="tableAvailabilityReport" msprop:Generator_TablePropName="AvailabilityReport" msprop:Generator_RowDeletingName="AvailabilityReportRowDeleting" msprop:Generator_UserTableName="AvailabilityReport" msprop:Generator_RowChangingName="AvailabilityReportRowChanging" msprop:Generator_RowEvHandlerName="AvailabilityReportRowChangeEventHandler" msprop:Generator_RowDeletedName="AvailabilityReportRowDeleted" msprop:Generator_RowEvArgName="AvailabilityReportRowChangeEvent" msprop:Generator_RowChangedName="AvailabilityReportRowChanged" msprop:Generator_RowClassName="AvailabilityReportRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CompanyName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCompanyName" msprop:Generator_ColumnPropNameInRow="CompanyName" msprop:Generator_ColumnPropNameInTable="CompanyNameColumn" msprop:Generator_UserColumnName="CompanyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MissionStatus" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMissionStatus" msprop:Generator_ColumnPropNameInRow="MissionStatus" msprop:Generator_ColumnPropNameInTable="MissionStatusColumn" msprop:Generator_UserColumnName="MissionStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_UserColumnName="Type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="7" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Count" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCount" msprop:Generator_ColumnPropNameInRow="Count" msprop:Generator_ColumnPropNameInTable="CountColumn" msprop:Generator_UserColumnName="Count" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MissionRequestReport" msprop:Generator_TableClassName="MissionRequestReportDataTable" msprop:Generator_TableVarName="tableMissionRequestReport" msprop:Generator_TablePropName="MissionRequestReport" msprop:Generator_RowDeletingName="MissionRequestReportRowDeleting" msprop:Generator_UserTableName="MissionRequestReport" msprop:Generator_RowChangingName="MissionRequestReportRowChanging" msprop:Generator_RowEvHandlerName="MissionRequestReportRowChangeEventHandler" msprop:Generator_RowDeletedName="MissionRequestReportRowDeleted" msprop:Generator_RowEvArgName="MissionRequestReportRowChangeEvent" msprop:Generator_RowChangedName="MissionRequestReportRowChanged" msprop:Generator_RowClassName="MissionRequestReportRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CompanyName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCompanyName" msprop:Generator_ColumnPropNameInRow="CompanyName" msprop:Generator_ColumnPropNameInTable="CompanyNameColumn" msprop:Generator_UserColumnName="CompanyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MissionDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMissionDate" msprop:Generator_ColumnPropNameInRow="MissionDate" msprop:Generator_ColumnPropNameInTable="MissionDateColumn" msprop:Generator_UserColumnName="MissionDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Type" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_UserColumnName="Type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="7" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Count" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCount" msprop:Generator_ColumnPropNameInRow="Count" msprop:Generator_ColumnPropNameInTable="CountColumn" msprop:Generator_UserColumnName="Count" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PayrollReport" msprop:Generator_TableClassName="PayrollReportDataTable" msprop:Generator_TableVarName="tablePayrollReport" msprop:Generator_TablePropName="PayrollReport" msprop:Generator_RowDeletingName="PayrollReportRowDeleting" msprop:Generator_UserTableName="PayrollReport" msprop:Generator_RowChangingName="PayrollReportRowChanging" msprop:Generator_RowEvHandlerName="PayrollReportRowChangeEventHandler" msprop:Generator_RowDeletedName="PayrollReportRowDeleted" msprop:Generator_RowEvArgName="PayrollReportRowChangeEvent" msprop:Generator_RowChangedName="PayrollReportRowChanged" msprop:Generator_RowClassName="PayrollReportRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EmployeeNo" msprop:Generator_ColumnVarNameInTable="columnEmployeeNo" msprop:Generator_ColumnPropNameInRow="EmployeeNo" msprop:Generator_ColumnPropNameInTable="EmployeeNoColumn" msprop:Generator_UserColumnName="EmployeeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CivilID" msprop:Generator_ColumnVarNameInTable="columnCivilID" msprop:Generator_ColumnPropNameInRow="CivilID" msprop:Generator_ColumnPropNameInTable="CivilIDColumn" msprop:Generator_UserColumnName="CivilID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriverName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDriverName" msprop:Generator_ColumnPropNameInRow="DriverName" msprop:Generator_ColumnPropNameInTable="DriverNameColumn" msprop:Generator_UserColumnName="DriverName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NoOfTrips" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNoOfTrips" msprop:Generator_ColumnPropNameInRow="NoOfTrips" msprop:Generator_ColumnPropNameInTable="NoOfTripsColumn" msprop:Generator_UserColumnName="NoOfTrips" type="xs:int" minOccurs="0" />
              <xs:element name="TotalNoofDays" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotalNoofDays" msprop:Generator_ColumnPropNameInRow="TotalNoofDays" msprop:Generator_ColumnPropNameInTable="TotalNoofDaysColumn" msprop:Generator_UserColumnName="TotalNoofDays" type="xs:int" minOccurs="0" />
              <xs:element name="TotalNumberOfMilage" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotalNumberOfMilage" msprop:Generator_ColumnPropNameInRow="TotalNumberOfMilage" msprop:Generator_ColumnPropNameInTable="TotalNumberOfMilageColumn" msprop:Generator_UserColumnName="TotalNumberOfMilage" type="xs:int" minOccurs="0" />
              <xs:element name="TotalDayOfSick" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotalDayOfSick" msprop:Generator_ColumnPropNameInRow="TotalDayOfSick" msprop:Generator_ColumnPropNameInTable="TotalDayOfSickColumn" msprop:Generator_UserColumnName="TotalDayOfSick" type="xs:int" minOccurs="0" />
              <xs:element name="ViolationCount" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnViolationCount" msprop:Generator_ColumnPropNameInRow="ViolationCount" msprop:Generator_ColumnPropNameInTable="ViolationCountColumn" msprop:Generator_UserColumnName="ViolationCount" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TMRMilageReport" msprop:Generator_TableClassName="TMRMilageReportDataTable" msprop:Generator_TableVarName="tableTMRMilageReport" msprop:Generator_TablePropName="TMRMilageReport" msprop:Generator_RowDeletingName="TMRMilageReportRowDeleting" msprop:Generator_UserTableName="TMRMilageReport" msprop:Generator_RowChangingName="TMRMilageReportRowChanging" msprop:Generator_RowEvHandlerName="TMRMilageReportRowChangeEventHandler" msprop:Generator_RowDeletedName="TMRMilageReportRowDeleted" msprop:Generator_RowEvArgName="TMRMilageReportRowChangeEvent" msprop:Generator_RowChangedName="TMRMilageReportRowChanged" msprop:Generator_RowClassName="TMRMilageReportRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MissionDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMissionDate" msprop:Generator_ColumnPropNameInRow="MissionDate" msprop:Generator_ColumnPropNameInTable="MissionDateColumn" msprop:Generator_UserColumnName="MissionDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="InboundDate" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnInboundDate" msprop:Generator_ColumnPropNameInRow="InboundDate" msprop:Generator_ColumnPropNameInTable="InboundDateColumn" msprop:Generator_UserColumnName="InboundDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="TMR" msprop:Generator_ColumnVarNameInTable="columnTMR" msprop:Generator_ColumnPropNameInRow="TMR" msprop:Generator_ColumnPropNameInTable="TMRColumn" msprop:Generator_UserColumnName="TMR">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TotalRequest" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotalRequest" msprop:Generator_ColumnPropNameInRow="TotalRequest" msprop:Generator_ColumnPropNameInTable="TotalRequestColumn" msprop:Generator_UserColumnName="TotalRequest" type="xs:int" minOccurs="0" />
              <xs:element name="AvgDuration" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAvgDuration" msprop:Generator_ColumnPropNameInRow="AvgDuration" msprop:Generator_ColumnPropNameInTable="AvgDurationColumn" msprop:Generator_UserColumnName="AvgDuration" type="xs:int" minOccurs="0" />
              <xs:element name="AvgMilage" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAvgMilage" msprop:Generator_ColumnPropNameInRow="AvgMilage" msprop:Generator_ColumnPropNameInTable="AvgMilageColumn" msprop:Generator_UserColumnName="AvgMilage" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="YardCountReport" msprop:Generator_TableClassName="YardCountReportDataTable" msprop:Generator_TableVarName="tableYardCountReport" msprop:Generator_TablePropName="YardCountReport" msprop:Generator_RowDeletingName="YardCountReportRowDeleting" msprop:Generator_UserTableName="YardCountReport" msprop:Generator_RowChangingName="YardCountReportRowChanging" msprop:Generator_RowEvHandlerName="YardCountReportRowChangeEventHandler" msprop:Generator_RowDeletedName="YardCountReportRowDeleted" msprop:Generator_RowEvArgName="YardCountReportRowChangeEvent" msprop:Generator_RowChangedName="YardCountReportRowChanged" msprop:Generator_RowClassName="YardCountReportRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MissionStatus" msprop:Generator_ColumnVarNameInTable="columnMissionStatus" msprop:Generator_ColumnPropNameInRow="MissionStatus" msprop:Generator_ColumnPropNameInTable="MissionStatusColumn" msprop:Generator_UserColumnName="MissionStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TruckCount" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTruckCount" msprop:Generator_ColumnPropNameInRow="TruckCount" msprop:Generator_ColumnPropNameInTable="TruckCountColumn" msprop:Generator_UserColumnName="TruckCount" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Drivers" />
      <xs:field xpath="mstns:CivilID" />
    </xs:unique>
    <xs:unique name="Vehicles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Vehicles" />
      <xs:field xpath="mstns:VehicleNumber" />
    </xs:unique>
    <xs:unique name="DriversAvailabilityStatusReport_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DriversAvailabilityStatusReport" />
      <xs:field xpath="mstns:CivilID" />
    </xs:unique>
    <xs:unique name="MissionRollupReport_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MissionRollupReport" />
      <xs:field xpath="mstns:MissionID" />
    </xs:unique>
    <xs:unique name="PayrollReport_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PayrollReport" />
      <xs:field xpath="mstns:CivilID" />
    </xs:unique>
  </xs:element>
</xs:schema>